pgsql: Doc: recommend "psql -X" for restoring pg_dump scripts.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: recommend "psql -X" for restoring pg_dump scripts.
Date: 2025-01-25 17:42:49
Message-ID: E1tbkBE-003URP-WE@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: recommend "psql -X" for restoring pg_dump scripts.

This practice avoids possible problems caused by non-default psql
options, such as disabling AUTOCOMMIT.

Author: Shinya Kato <Shinya11(dot)Kato(at)oss(dot)nttdata(dot)com>
Reviewed-by: Robert Treat <rob(at)xzilla(dot)net>
Discussion: https://postgr.es/m/96ff23a5d858ff72ca8e823a014d16fe@oss.nttdata.com
Backpatch-through: 13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d83a108c10a3ec886a24c620a915aa2c5bc023aa

Modified Files
--------------
doc/src/sgml/backup.sgml | 22 ++++++++++++++--------
doc/src/sgml/ref/pg_dump.sgml | 10 +++++++++-
doc/src/sgml/ref/pg_dumpall.sgml | 15 +++++++++++++--
3 files changed, 36 insertions(+), 11 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Noah Misch 2025-01-25 19:29:54 pgsql: At update of non-LP_NORMAL TID, fail instead of corrupting page
Previous Message Andres Freund 2025-01-25 16:43:59 pgsql: Change shutdown sequence to terminate checkpointer last