| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | 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 17:29:18 |
| Message-ID: | 1292868.1653326958@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> On 5/23/22 9:54 AM, Rob Sargent wrote:
>> Roger that, but does the dump of a database name the tablespaces from
>> which the objects were retrieved? And if so, is that accessible?
> Would indicate it does. I don't have cluster set up with tablespaces to
> test, but I would try:
> pg_restore -l <custom_format_file>
AFAICS, the output produced by -l doesn't mention objects' tablespaces.
You could see them by extracting the plain text archive and grepping
for object comments that include a tablespace name:
pg_restore -s -f - archive_file | grep Tablespace:
It looks to me like that will only appear for tables with non-default
tablespaces.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-05-23 17:32:39 | Re: psql connect over ssl load balancer |
| Previous Message | dzagashev@gmail.com | 2022-05-23 17:28:15 | psql connect over ssl load balancer |