| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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:31:15 |
| Message-ID: | 4592d00b-23e9-3982-84f7-c376932ac5cc@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/23/22 12:15, Tom Lane wrote:
> 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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-05-23 18:59:03 | Re: list tablespaces named in custom format dump |
| Previous Message | Tom Lane | 2022-05-23 18:15:02 | Re: list tablespaces named in custom format dump |