Re: list tablespaces named in custom format dump

On 5/23/22 11:04 AM, Rob Sargent wrote:

> Thanks Adrian.  There's enough wiggle room in there for me to at least 
> try the restore. Linus file command tells me
> 
>     db.dump: PostgreSQL custom database dump - v1.13-0

The

pg_restore -l <custom_format_file>

command will show the relevant information at top of file so:

pg_restore -l pg14_test.out > toc.txt

head -n 15 toc.txt
;
; Archive created at 2022-05-23 10:24:23 PDT
;     dbname: test
;     TOC Entries: 745
;     Compression: -1
;     Dump Version: 1.14-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 14.2
;     Dumped by pg_dump version: 14.2
;
;
; Selected TOC Entries:

> 
> That dump was from a version 10 server.  Any guess at how that "v1.13-0" 
> relates to the server version?  Dumps from the current pg14 server  say 
> "v1.14-0" so it looks to me like the dumps were done with v13 
> pg-restore.  This surprises me, but I do not manage the server.  Maybe 
> my dump file doesn't have anything pg14 restore can't handle.. we'll see

I have abused this on occasion and succeeded, though sometimes it 
involves some tweaks.

> 
> Thanks again, all.


-- 
Adrian Klaver
adrian.klaver@aklaver.com