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?