| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: list tablespaces named in custom format dump |
| Date: | 2022-05-23 18:15:02 |
| Message-ID: | 1304637.1653329702@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Rob Sargent <robjsargent(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2022-05-23 18:31:15 | Re: list tablespaces named in custom format dump |
| Previous Message | Adrian Klaver | 2022-05-23 18:10:49 | Re: list tablespaces named in custom format dump |