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
