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