Re: list tablespaces named in custom format dump - Mailing list pgsql-general

From Rob Sargent
Subject Re: list tablespaces named in custom format dump
Date
Msg-id 4592d00b-23e9-3982-84f7-c376932ac5cc@gmail.com
Whole thread Raw
In response to Re: list tablespaces named in custom format dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: list tablespaces named in custom format dump
List pgsql-general
On 5/23/22 12:15, Tom Lane wrote:
Rob Sargent <robjsargent@gmail.com> writes:
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
That dump was from a version 10 server.  Any guess at how that "v1.13-0" 
relates to the server version?
It doesn't, it's just a more-or-less-magic identifier for the dump
file's format version, with no connection to any user-visible
release number.  What you should try is

pg_restore -f - db.dump | head

which should provide some comments telling you the originating
server version and pg_dump version.
			regards, tom lane

OK, back to reality: version 10 dump. 

The output of from head command is very different that Adrian shows but I'm still left giving pg_restore(14) a shot.  Getting older server will be challenging.

Much appreciated,
rjs


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: list tablespaces named in custom format dump
Next
From: Adrian Klaver
Date:
Subject: Re: list tablespaces named in custom format dump