Re: list tablespaces named in custom format dump

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: list tablespaces named in custom format dump
Date: 2022-05-23 16:50:13
Message-ID: 9013c93e-3f01-f40a-4e14-7b1c9d7b065d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
"

> Thanks,
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2022-05-23 16:54:22 Re: list tablespaces named in custom format dump
Previous Message Rob Sargent 2022-05-23 16:45:48 list tablespaces named in custom format dump