Home Explore Blog CI



postgresql

26th chunk of `doc/src/sgml/release-18.sgml`
0f01b5163a93a59a14d782112bd08563255d75d09f8136180000000100000fb5
 (Jeff Davis)
<ulink url="&commit_baseurl;bde2fb797">&sect;</ulink>
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-25 [9c49f0e8c] pg_dump: Add - -sequence-data.
Author: Nathan Bossart <nathan@postgresql.org>
2025-05-07 [acea3fc49] pg_dumpall: Add - -sequence-data.
-->

<listitem>
<para>
Add pg_dump and pg_dumpall option --sequence-data to dump sequence data that would normally be excluded (Nathan Bossart)
<ulink url="&commit_baseurl;9c49f0e8c">&sect;</ulink>
<ulink url="&commit_baseurl;acea3fc49">&sect;</ulink>
</para>
</listitem>

<!--
Author: Jeff Davis <jdavis@postgresql.org>
2025-02-20 [1fd1bd871] Transfer statistics during pg_upgrade.
-->

<listitem>
<para>
Add pg_dump, pg_dumpall, and pg_restore options --statistics-only, --no-statistics, --no-data, and --no-schema (Corey Huinker, Jeff Davis)
<ulink url="&commit_baseurl;1fd1bd871">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-16 [cd3c45125] pg_dump, pg_dumpall, pg_restore: Add - -no-policies optio
-->

<listitem>
<para>
Add option --no-policies to disable row level security policy processing in pg_dump, pg_dumpall, pg_restore (Nikolay Samokhvalov)
<ulink url="&commit_baseurl;cd3c45125">&sect;</ulink>
</para>

<para>
This is useful for migrating to systems with different policies.
</para>
</listitem>

     </itemizedlist>

    </sect4>

    <sect4 id="release-18-pgupgrade">
     <title><link linkend="pgupgrade"><application>pg_upgrade</application></link></title>

     <itemizedlist>

<!--
Author: Jeff Davis <jdavis@postgresql.org>
2025-02-20 [1fd1bd871] Transfer statistics during pg_upgrade.
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-18 [c9d502eb6] Update guidance for running vacuumdb after pg_upgrade.
Author: Nathan Bossart <nathan@postgresql.org>
2025-04-30 [d5f1b6a75] Further adjust guidance for running vacuumdb after pg_up
Author: Jeff Davis <jdavis@postgresql.org>
2025-02-20 [1fd1bd871] Transfer statistics during pg_upgrade.
-->

<listitem>
<para>
Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Nathan Bossart)
<ulink url="&commit_baseurl;1fd1bd871">&sect;</ulink>
<ulink url="&commit_baseurl;c9d502eb6">&sect;</ulink>
<ulink url="&commit_baseurl;d5f1b6a75">&sect;</ulink>
<ulink url="&commit_baseurl;1fd1bd871">&sect;</ulink>
</para>

<para>
Extended statistics are not preserved.  Also add pg_upgrade option --no-statistics to disable statistics preservation.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [40e2e5e92] Introduce framework for parallelizing various pg_upgrade
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [6d3d2e8e5] pg_upgrade: Parallelize retrieving relation information.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [7baa36de5] pg_upgrade: Parallelize subscription check.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [46cad8b31] pg_upgrade: Parallelize retrieving loadable libraries.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [6ab8f27bc] pg_upgrade: Parallelize retrieving extension updates.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [bbf83cab9] pg_upgrade: Parallelize data type checks.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [9db3018cf] pg_upgrade: Parallelize contrib/isn check.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [c34eabfbb] pg_upgrade: Parallelize postfix operator check.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [cf2f82a37] pg_upgrade: Parallelize incompatible polymorphics check.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [f93f5f7b9] pg_upgrade: Parallelize WITH OIDS check.
Author: Nathan Bossart <nathan@postgresql.org>
2024-09-16 [c880cf258] pg_upgrade: Parallelize encoding conversion check.
-->

<listitem>
<para>
Allow pg_upgrade to process database checks in parallel (Nathan Bossart)
<ulink url="&commit_baseurl;40e2e5e92">&sect;</ulink>
<ulink url="&commit_baseurl;6d3d2e8e5">&sect;</ulink>

Title: Enhancements to pg_dump and pg_upgrade in PostgreSQL 18
Summary
This section describes updates to pg_dump and pg_upgrade. pg_dump, pg_dumpall, and pg_restore gain the option --no-policies to disable row level security policy processing. pg_upgrade can now preserve optimizer statistics, with the option --no-statistics to disable this. The tool also now processes database checks in parallel, improving performance.