Home • Explore • Blog • CI
☰



postgresql
25th chunk of `doc/src/sgml/release-18.sgml`
6eaea81c0757935f2f8c21dc04cfdbac8957dcb9b8422b410000000100000fa3

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-18 [edba754f0] vacuumdb: Add option for analyzing only relations missin
Author: Nathan Bossart <nathan@postgresql.org>
2025-04-30 [987910502] vacuumdb: Don't skip empty relations in - -missing-stats-
-->

<listitem>
<para>
Add vacuumdb option --missing-stats-only to compute only missing optimizer statistics (Corey Huinker, Nathan Bossart)
<ulink url="&commit_baseurl;edba754f0">&sect;</ulink>
<ulink url="&commit_baseurl;987910502">&sect;</ulink>
</para>

<para>
This option can only be used by --analyze-only and --analyze-in-stages.
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2025-03-17 [99aeb8470] pg_combinebackup: Add -k, - -link option.
-->

<listitem>
<para>
Add pg_combinebackup option -k/--link to enable hard linking (Israel Barth Rubio, Robert Haas)
<ulink url="&commit_baseurl;99aeb8470">&sect;</ulink>
</para>

<para>
Only some files can be hard linked.  This should not be used if the backups will be used independently.
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2024-09-27 [8dfd31290] pg_verifybackup: Verify tar-format backups.
-->

<listitem>
<para>
Allow pg_verifybackup to verify tar-format backups (Amul Sul)
<ulink url="&commit_baseurl;8dfd31290">&sect;</ulink>
</para>
</listitem>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2025-03-12 [4ecdd4110] pg_rewind: Add dbname to primary_conninfo when using - -w
-->

<listitem>
<para>
If pg_rewind's --source-server specifies a database name, use it in --write-recovery-conf output (Masahiko Sawada)
<ulink url="&commit_baseurl;4ecdd4110">&sect;</ulink>
</para>
</listitem>

<!--
Author: Masahiko Sawada <msawada@postgresql.org>
2025-02-21 [30666d185] pg_resetwal: Add - -char-signedness option to change the
-->

<listitem>
<para>
Add pg_resetwal option --char-signedness to change the default char signedness (Masahiko Sawada)
<ulink url="&commit_baseurl;30666d185">&sect;</ulink>
</para>
</listitem>

   </itemizedlist>


    <sect4 id="release-18-pgdump">
     <title><link
     linkend="app-pgdump"><application>pg_dump</application></link>/<link
     linkend="app-pg-dumpall"><application>pg_dumpall</application></link>/<link
     linkend="app-pgrestore"><application>pg_restore</application></link></title>

     <itemizedlist>

<!--
Author: Andrew Dunstan <andrew@dunslane.net>
2025-04-04 [1495eff7b] Non text modes for pg_dumpall, correspondingly change pg
-->

<listitem>
<para>
Allow pg_dumpall to dump in the same output formats as pg_dump supports (Mahendra Singh Thalor, Andrew Dunstan)
<ulink url="&commit_baseurl;1495eff7b">&sect;</ulink>
</para>

<para>
Also modify pg_restore to handle such dumps.  Previously pg_dumpall only supported text format.
</para>
</listitem>

<!--
Author: Jeff Davis <jdavis@postgresql.org>
2025-03-25 [bde2fb797] Add pg_dump - -with-{schema|data|statistics} options.
-->

<listitem>
<para>
Add pg_dump options --with-schema, --with-data, and --with-statistics (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,
Title: PostgreSQL 18: Server Application Updates (vacuumdb, pg_combinebackup, pg_verifybackup, pg_rewind, pg_resetwal) and pg_dump Enhancements
Summary
This section details updates to several PostgreSQL server applications. vacuumdb receives the --missing-stats-only option for computing missing optimizer statistics. pg_combinebackup gains the -k/--link option to enable hard linking of backup files. pg_verifybackup is enhanced to verify tar-format backups. pg_rewind now uses the database name specified in --source-server for --write-recovery-conf output. pg_resetwal includes the --char-signedness option to change the default char signedness. Furthermore, pg_dump related tools receive significant upgrades: pg_dumpall can now dump in the same output formats as pg_dump, while pg_dump gains --with-schema, --with-data, and --with-statistics options. Both pg_dump and pg_dumpall receive the --sequence-data option to include sequence data. Also included are options for managing statistics during pg_dump, pg_dumpall, and pg_restore, like --statistics-only, --no-statistics, --no-data, and --no-schema.