</para>

<para>

This mode could cause server startup failure ifthe database serverstopped abruptly while in this mode. The non-exclusive backup mode requires a continuous database connection during the backup.

Ifthe database serverstops abruptly while in this mode, the server could fail to start. The non-exclusive backup mode requires a continuous database connection during the backup.

</para>

</listitem>

2021-11-06 [cbe25dcff] Disallow making an empty lexeme via array_to_tsvector().

-->

<listitem>

<para>

Allow tsvector_delete_arr() and tsvector_setweight_by_filter() accept empty array elements (Jean-Christophe Arnu)

</para>

<para>

These lexemes are not stored so the acceptance of empty array elements is not a problem.

</para>

</listitem>

<!--

Author: Tom Lane <tgl@sss.pgh.pa.us>

2021-11-06 [cbe25dcff] Disallow making an empty lexeme via array_to_tsvector().

-->

<listitem>

<para>

Generate an error if array_to_tsvector() is passed an empty array element (Jean-Christophe Arnu)

</para>

<para>

This accepts numeric formats like ".1" and "1.", anddisallow trailing junk after numeric literals, like "1.type()".

This accepts numeric formats like ".1" and "1.", anddisallows trailing junk after numeric literals, like "1.type()".

</para>

</listitem>

</para>

<para>

This effectively means that onlysuper users, roles with bypassrls, and table owners can replicate into tables with row-level security policies. (The actual row-level security policies are not checked,

This effectively means that onlysuperusers, roles with bypassrls, and table owners can replicate into tables with row-level security policies. (The actual row-level security policies are not checked,

only whether row-level security policies are enforced for subscribing users.)

</para>

</listitem>

</para>

<para>

This will cause setseed() followed by random() to return a different value on older servers.

This will cause setseed() followed by random() to return a different valuethanon older servers.

</para>

</listitem>

</para>

<para>

The Postgres default has alwaysbeen to treat NULLindexedvaluesas distinct, but this can now be changed by creating constraints and indexes using UNIQUE NULLS NOT DISTINCT.

Previously NULL values were always indexed as distinct values, but this can now be changed by creating constraints and indexes using UNIQUE NULLS NOT DISTINCT.

</para>

</listitem>

<listitem>

<para>

Have extended statisticstrackstatistics for atable's children separately (Tomas Vondra, Justin Pryzby)

Allow extended statisticsto recordstatistics for aparent with all it children (Tomas Vondra, Justin Pryzby)

</para>

<para>

Regular statistics already trackedchild andnon-child statistics separately.

Regular statistics already trackedparent andparent/all-children statistics separately.

</para>

</listitem>

<listitem>

<para>

Allow WAL full page writes to use LZ4 andZSTD compression (Andrey Borodin, Justin Pryzby)

Allow WAL full page writes to use LZ4 andZstandard compression (Andrey Borodin, Justin Pryzby)

</para>

<para>

</para>

<para>

Previously only thesuper users could perform such backups.

Previously only thesuperusers could perform such backups.

</para>

</listitem>

</para>

<para>

Previouslythese viewscould only be run bysuper users.

Previouslycheckpointscould only be run bysuperusers.

</para>

</listitem>

</para>

<para>

Previously these views could only berun bysuper users.

Previously these views could only beaccessed bysuperusers.

</para>

</listitem>

</para>

<para>

Previously this function could only be run bysuper users.

Previously this function could only be run bysuperusers.

</para>

</listitem>

</para>

<para>

Previously runtime-computed values data_checksums, wal_segment_size, and data_directory_mode would report values that would not be accurate on the running server. They also can only be

Previously runtime-computed values data_checksums, wal_segment_size, and data_directory_mode would report values that would not be accurate on the running server.

</para>

</listitem>

<para>

Add function pg_settings_get_flags() to get the flags of server-side variables (Justin Pryzby)

</para>

</listitem>

<!--

Author: Thomas Munro <tmunro@postgresql.org>

2022-01-15 [7170f2159] Allow "in place" tablespaces.

-->

<listitem>

<para>

Add server variable allow_in_place_tablespaces for tablespace testing (Thomas Munro)

</para>

</listitem>

</itemizedlist>

<listitem>

<para>

Add support for LZ4 andZSTD compression of server-side base backups (Jeevan Ladhe, Robert Haas)

Add support for LZ4 andZstandard compression of server-side base backups (Jeevan Ladhe, Robert Haas)

</para>

</listitem>

</para>

<para>

The newoptions causes the column names to be output, and optionally verified on input.

The newoption causes the column names to be output, and optionally verified on input.

</para>

</listitem>

</para>

<para>

Previously, all of the columns in the foreign key were alwayseffected.

Previously, all of the columns in the foreign key were alwaysaffected.

</para>

</listitem>

</para>

<para>

Previous the actual schema name was used.

Previously the actual schema name was used.

</para>

</listitem>

</para>

</listitem>

<!--

Author: Tom Lane <tgl@sss.pgh.pa.us>

2021-11-06 [cbe25dcff] Disallow making an empty lexeme via array_to_tsvector().

-->

<listitem>

<para>

Allow tsvector_delete_arr() and tsvector_setweight_by_filter() to accept empty array elements (Jean-Christophe Arnu)

</para>

<para>

These lexemes are not stored so the acceptance of empty array elements is not a problem.

</para>

</listitem>

<!--

Author: David Rowley <drowley@postgresql.org>

2021-07-09 [ca2e4472b] Teach pg_size_pretty and pg_size_bytes about petabytes

<listitem>

<para>

Fixinforcement of PL/pgSQL variable CONSTANT markings (Tom Lane)

Fixenforcement of PL/pgSQL variable CONSTANT markings (Tom Lane)

</para>

<para>

<listitem>

<para>

Allow IP address matching against a server's certificate Subject Alternative Name (Jacob Champion)

Allow IP address matching against a server certificate's Subject Alternative Name (Jacob Champion)

</para>

</listitem>

<listitem>

<para>

Allow libpq's SSL private to be owned by the root user (David Steele)

Allow libpq's SSL privatekey fileto be owned by the root user (David Steele)

</para>

</listitem>

<listitem>

<para>

Have psql output alloutput if multiple queries are passed to the server at once (Fabien Coelho)

Have psql output allresults if multiple queries are passed to the server at once (Fabien Coelho)

</para>

<para>

This can be disabled setting SHOW_ALL_RESULTS.

This can be disabledbysetting SHOW_ALL_RESULTS.

</para>

</listitem>

<listitem>

<para>

Allow pg_basebackup to decompress LZ4 andZSTD compressed server-side base backups, and LZ4 andZSTD compress output files (Dipesh Pandit, Jeevan Ladhe)

Allow pg_basebackup to decompress LZ4 andZstandard compressed server-side base backups, and LZ4 andZstandard compress output files (Dipesh Pandit, Jeevan Ladhe)

</para>

</listitem>

<listitem>

<para>

Allow pg_basebackup's --compress option to control the compression method (Michael Paquier, Robert Haas)

Allow pg_basebackup's --compress option to control the compression methodand options(Michael Paquier, Robert Haas)

</para>

<para>

<listitem>

<para>

Allow pg_basebackup to compress on the serverslide and decompress on the client side before storage (Dipesh Pandit)

Allow pg_basebackup to compress on the serverside and decompress on the client side before storage (Dipesh Pandit)

</para>

<para>

</para>

<para>

This is enabled via --compression-method=lz4 and requires binaries to be built using --with-lz4.

This is enabled via --compression=lz4 and requires binaries to be built using --with-lz4.

</para>

</listitem>

</para>

<para>

The new --compression-method option controls the type of compression, rather than just relying on --compress.

The new --compression option controls the type of compression, rather than just relying on --compress.

</para>

</listitem>

<para>

Previously, pg_receivewal would start based on the WAL file stored in the local archive directory, or at the sending server's current WAL flush location. With this change, if the sending server is running

Postgres 15 or later, the local archive directory is empty, and a replication slot is specified, the replicationslots restart point will be used.

Postgres 15 or later, the local archive directory is empty, and a replication slot is specified, the replicationslot's restart point will be used.

</para>

</listitem>

<listitem>

<para>

Add dump/restore option --no-table-access-method to force restore to use only the default table access method (Justin Pryzby)

</para>

<para>

This is for portability in restoring from systems using non-default table access methods.

Add dump/restore option --no-table-access-method to force restore to only use the default table access method (Justin Pryzby)

</para>

</listitem>

</para>

<para>

Previously only the first invalid connection setting database was reported.

Previously only the firstdatabase with aninvalid connection setting was reported.

</para>

</listitem>

<listitem>

<para>

Add configure option --with-zstd to enableZSTD build (Jeevan Ladhe, Robert Haas, Michael Paquier)

Add configure option --with-zstd to enableZstandard builds (Jeevan Ladhe, Robert Haas, Michael Paquier)

</para>

</listitem>

<listitem>

<para>

Add new protocol message TARGET tospecific a new COPY method to be for base backups (Robert Haas)

Add new protocol message TARGET tospecify a new COPY method to be for base backups (Robert Haas)

</para>

<para>

<listitem>

<para>

Add extensions to define their own WAL resource managers (Jeff Davis)

Allow extensions to define their own WAL resource managers (Jeff Davis)

</para>

</listitem>

<!--

Author: Thomas Munro <tmunro@postgresql.org>

2022-01-15 [7170f2159] Allow "in place" tablespaces.

-->

<listitem>

<para>

Add server variable allow_in_place_tablespaces for tablespace testing (Thomas Munro)

</para>

</listitem>

<listitem>

<para>

Automatically export server variables using PGDLLIMPORT on Windows (Robert Haas)

Export all server variables using PGDLLIMPORT on Windows (Robert Haas)

</para>

<para>

</para>

<para>

This is enabled with the "parallel_commit"postgres_fdw option.

This is enabled with theCREATE SERVER option"parallel_commit"when using postgres_fdw.

</para>

</listitem>