hi. Currently, pg_retore says --exit-on-error Exit if an error is encountered while sending SQL commands to the database. The default is to continue and to display a count of errors at the end of the restoration. Do we need to apply this to restore executing global commands (create role, create tablespace)? If not then we need to put some words in pg_restoe --exit-on-error option saying that while restoring global objects --exit-on-error option is ignored.
IMHO, in pg_restore.sgml, we need words explicitly saying that when restoring multiple databases, all the specified options will apply to each individual database. I tested the following options for restoring multiple databases. The results look good to me. --index=index --table=table --schema-only --transaction-size --no-comments some part of (--filter=filename) --exclude-schema=schema attach is a minor cosmetic change.
v17_pg_dumpall.minorchange
Description: Binary data
