Horton

Re: PG 14 release notes, first draft

Bruce Momjian <bruce@momjian.us>

View thread View on postgr.es
From: Bruce Momjian <bruce@momjian.us>
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-05-11T02:49:08Z
Lists: pgsql-hackers 
On Mon, May 10, 2021 at 10:53:03PM +0900, Ian Lawrence Barwick wrote:
> 2021年5月10日(月) 15:03 Bruce Momjian <bruce@momjian.us>:
> >
> > I have committed the first draft of the PG 14 release notes.  You can
> > see the most current  build of them here:
> >
> >         https://momjian.us/pgsql_docs/release-14.html
> >
> > I need clarification on many items, and the document still needs its
> > items properly ordered, and markup added.  I also expect a lot of
> > feedback.
> >
> > I plan to work on completing this document this coming week in
> > preparation for beta next week.
> 
> This misses the change of default value, and is a bit unclear:
> 
> > Remove password_encryption's support for boolean values, e.g. true (Peter Eisentraut)
> >
> > Previous boolean values enabled md5.  Now, only the md5 string does this.
> 
> I'd suggest something along these lines:
> 
> > The default for password_encryption is now "scram-sha-256" (Peter Eisentraut)
> >
> > The pseudo-boolean values "true", "on", "yes" and "1" are no longer accepted as an alias for "md5".
> 
> (It hasn't been a true boolean setting since Pg 9.6).

I reworeded it to:

	<listitem>
	<!--
	Author: Peter Eisentraut <peter@eisentraut.org>
	2020-06-10 [c7eab0e97] Change default of password_encryption to scram-sha-256
	-->
	
	<para>
	Limit the ways password_encryption can enable md5 hashing (Peter Eisentraut)
	</para>
	
	<para>
	Previously on/true/yes/1 values enabled md5.  Now, only the string md5 does this.
	</para>
	</listitem>

I also have this entry:

	<listitem>
	<!--
	Author: Peter Eisentraut <peter@eisentraut.org>
	2020-06-10 [c7eab0e97] Change default of password_encryption to scram-sha-256
	-->
	
	<para>
	Change password_encryption's default to scram-sha-256 (Peter Eisentraut)
	</para>
	
	<para>
	Previously it was md5.
	</para>
	</listitem>

I am hesitant to merge them since they are different changes.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Commits

  1. doc: add mention of +4GB windows file handling in PG14 relnotes

  2. doc: PG 14 relnotes fixes

  3. doc: PG 14 relnote updates

  4. doc: PG 14 relnotes, adjust pg_{read|write}_all_data entry

  5. Update PG 14 relnotes for vacuum_cost_page_miss

  6. doc: update PG 14 release notes with recent feedback

  7. Update replication statistics after every stream/spill.

  8. Add information of total data processed to replication slot stats.

  9. Use NameData datatype for slotname in stats.

  10. Add back vacuum_cleanup_index_scale_factor parameter.

  11. Don't consider newly inserted tuples in nbtree VACUUM.

  12. pgbench: Improve time logic.

  13. Track total amounts of times spent writing and syncing WAL data to disk.

  14. Allow decoding at prepare time in ReorderBuffer.

  15. Extend the output plugin API to allow decoding of prepared xacts.

  16. Fix nbtree cleanup-only VACUUM stats inaccuracies.

  17. Execute invalidation messages for each XLOG_XACT_INVALIDATIONS message

  18. Fix our Windows stat() emulation to handle file sizes > 4GB.

  19. Trigger autovacuum based on number of INSERTs

  20. Speed up planning when partitions can be pruned at plan time.

  21. Remove support for password_encryption='off' / 'plain'.

  22. Increase work_mem and maintenance_work_mem defaults by 4x