Doc: recommend "psql -X" for restoring pg_dump scripts.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Jan 2025 17:42:05 +0000 (12:42 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Jan 2025 17:42:05 +0000 (12:42 -0500)
commit4106942f004fdd789ea4b35be0585c1f8268744d
tree4b178bb2c8b1826ab4d750286cb8ba832ca2d345
parentfb60050f42019b1dc5781fa0f43ca0fa7f0de9c7
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: http://postgr.es/m/96ff23a5d858ff72ca8e823a014d16fe@oss.nttdata.com
Backpatch-through: 13
doc/src/sgml/backup.sgml
doc/src/sgml/ref/pg_dump.sgml
doc/src/sgml/ref/pg_dumpall.sgml