Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: d83a108c10a3ec886a24c620a915aa2c5bc023aa
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2025-01-25T17:42:22Z
Releases: 18.0 
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

Files

PathChange+/−
doc/src/sgml/backup.sgml modified +14 −8
doc/src/sgml/ref/pg_dumpall.sgml modified +13 −2
doc/src/sgml/ref/pg_dump.sgml modified +9 −1

Documentation touched

Discussion