Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject pgsql: Doc: recommend "psql -X" for restoring pg_dump scripts.
Date
Msg-id E1tbkBE-003URP-WE@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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.Kato@oss.nttdata.com>
Reviewed-by: Robert Treat <rob@xzilla.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(-)

pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Change shutdown sequence to terminate checkpointer last
Next
From: Noah Misch
Date:
Subject: pgsql: At update of non-LP_NORMAL TID, fail instead of corrupting page