On 5/23/22 10:50, Adrian Klaver wrote:
On 5/23/22 9:45 AM, Rob Sargent wrote:
Using pg 14, is it easy (possible) to list the tablespaces used in a
custom format dump. Are the definitions included?
https://www.postgresql.org/docs/14/app-pgdump.html
"pg_dump only dumps a single database. To back up an entire cluster,
or to back up global objects that are common to all databases in a
cluster (such as roles and tablespaces), use pg_dumpall."
https://www.postgresql.org/docs/14/app-pg-dumpall.html
"-g
--globals-only
Dump only global objects (roles and tablespaces), no databases.
"
Roger that, but does the dump of a database name the tablespaces from
which the objects were retrieved? And if so, is that accessible?
