On Thu, May 11, 2017 at 11:50:03PM -0400, Tom Lane wrote: > Michael Paquier <michael.paqu...@gmail.com> writes: > > Bruce, the release notes do not mention yet that support for cleartext > > passwords is removed. This has been done recently by Heikki in > > eb61136d. This has as consequence that CREATE ROLE PASSWORD > > UNENCRYPTED returns an error, and that password_encryption loses its > > value 'off' compared to last releases. > > The release notes only say that they're current through 4-22. The > usual process is to update them in batches every so often. It'd be > great if Bruce has time to do another round before Monday, but the > current situation is not really broken.
Done. Applied patch attached. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
diff --git a/doc/src/sgml/release-10.sgml b/doc/src/sgml/release-10.sgml new file mode 100644 index 6497641..4f953dc *** a/doc/src/sgml/release-10.sgml --- b/doc/src/sgml/release-10.sgml *************** *** 128,133 **** --- 128,155 ---- <listitem> <!-- + Author: Tom Lane <t...@sss.pgh.pa.us> 2017-05-11 [d10c626de] Rename + WAL-related functions and views to use "lsn" not + --> + <para> + Rename <acronym>WAL</>-related functions and views to use <literal>lsn</> + instead of <literal>location</> (David Rowley) + </para> + </listitem> + + <listitem> + <!-- + Author: Peter Eisentraut <pete...@gmx.net> 2017-05-12 [c1a7f64b4] + Replace "transaction log" with "write-ahead log" + --> + <para> + Rename<acronym>WAL</>-related functions and views to use <literal>lsn</> + instead of <literal>location</> (David Rowley) + </para> + </listitem> + + <listitem> + <!-- Author: Andres Freund <and...@anarazel.de> 2017-01-18 [69f4b9c85] Move targetlist SRF handling from expression evaluation Author: Tom Lane <t...@sss.pgh.pa.us> *************** *** 184,189 **** --- 206,233 ---- <listitem> <!-- Author: Heikki Linnakangas <heikki.linnakan...@iki.fi> + 2017-05-08 [eb61136dc] Remove support for password_encryption='off' / 'plain'. + --> + <para> + Remove the ability to store unencrypted passwords on the server + (Heikki Linnakangas) + </para> + + <para> + The server-side variable <xref linkend="guc-password-encryption"> + no longer supports <literal>off</> or <literal>plain</>. + The <literal>UNENCRYPTED</> option is no longer supported for + <command>CREATE/ALTER USER ... PASSSWORD</>. Similarly, the + <option>--unencrypted</> has been removed from <command>createuser</>. + The default for <option>password_encryption</> is still + <literal>md5</>, and users migrating passwords from older systems + will have them stored encrypted by default in this release. + </para> + </listitem> + + <listitem> + <!-- + Author: Heikki Linnakangas <heikki.linnakan...@iki.fi> 2016-10-26 [94aceed31] Support multi-dimensional arrays in PL/python. Author: Heikki Linnakangas <heikki.linnakan...@iki.fi> 2016-10-26 [cfd9c87a5] Only treat Python Lists as array dimensions. *************** *** 1418,1424 **** <para> Specifically, defaults were changed for <xref linkend="guc-wal-level">, <xref linkend="guc-max-wal-senders">, ! and <xref linkend="guc-max-replication-slots">. </para> </listitem> --- 1462,1469 ---- <para> Specifically, defaults were changed for <xref linkend="guc-wal-level">, <xref linkend="guc-max-wal-senders">, ! <xref linkend="guc-max-replication-slots">, and <xref ! linkend="guc-hot-standby">. </para> </listitem> *************** *** 2199,2204 **** --- 2244,2269 ---- <listitem> <!-- + Author: Heikki Linnakangas <heikki.linnakan...@iki.fi> + 2017-05-03 [8f8b9be51] Add PQencryptPasswordConn function to libpq, use it in p + --> + <para> + Add function <link + linkend="libpq-pqencryptpasswordconn"><function>PQencryptPasswordConn()</></> + to allow creation of more types of encrypted passwords on the + client-side (Michael Paquier, Heikki Linnakangas) + </para> + + <para> + Previously only <literal>MD5</> passwords could be created using <link + linkend="libpq-pqencryptpassword"><function>PQencryptPassword()</></>. + This new function can also create <link + linkend="auth-pg-hba-conf"><literal>SCRAM-SHA-256</></> passwords. + </para> + </listitem> + + <listitem> + <!-- Author: Tom Lane <t...@sss.pgh.pa.us> 2016-08-16 [a7b5573d6] Remove separate version numbering for ecpg preprocessor. --> *************** *** 2847,2852 **** --- 2912,2919 ---- <!-- Author: Robert Haas <rh...@postgresql.org> 2016-10-21 [7012b132d] postgres_fdw: Push down aggregates to remote servers. + Author: Peter Eisentraut <pete...@gmx.net> + 2017-04-24 [332bec1e6] postgres_fdw: Fix join push down with extensions --> <para> Push aggregates to foreign data wrapper servers, where possible *************** *** 2858,2864 **** from the foreign data wrapper server, and offloads aggregate computation from the requesting server. The <link linkend="postgres-fdw"><application>postgres_fdw</></> is able to ! perform this optimization. </para> </listitem> --- 2925,2932 ---- from the foreign data wrapper server, and offloads aggregate computation from the requesting server. The <link linkend="postgres-fdw"><application>postgres_fdw</></> is able to ! perform this optimization. There are also improvements in ! pushing down joins involving extensions. </para> </listitem>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers