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

From Tom Lane
Subject Re: list tablespaces named in custom format dump
Date
Msg-id 1304637.1653329702@sss.pgh.pa.us
Whole thread Raw
In response to Re: list tablespaces named in custom format dump  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: list tablespaces named in custom format dump
List pgsql-general
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



pgsql-general by date:

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