Adrian Klaver <adrian.klaver@aklaver.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