Doc: recommend "psql -X" for restoring pg_dump scripts.
authorTom Lane <[email protected]>
Sat, 25 Jan 2025 17:42:05 +0000 (12:42 -0500)
committerTom Lane <[email protected]>
Sat, 25 Jan 2025 17:42:22 +0000 (12:42 -0500)
commitd83a108c10a3ec886a24c620a915aa2c5bc023aa
tree4539337b99642dcc2bf115581563b5e9db185133
parent87a6690cc69530703b7da7e72769bae2ac5b2e77
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 <[email protected]>
Reviewed-by: Robert Treat <[email protected]>
Discussion: https://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