| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "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:59:03 |
| Message-ID: | 756c6a6f-08c0-39f3-a697-516ee3acd77c@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/23/22 11:31, Rob Sargent wrote:
> On 5/23/22 12:15, Tom Lane wrote:
>>
>> 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.
Different view of the information.
pg_restore -l has more detail, but all you are interested in is this:
-- Dumped from database version 14.2
-- Dumped by pg_dump version 14.2
anyway.
As to older version, how are you installing Postgres?
>
> Much appreciated,
> rjs
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2022-05-23 19:26:48 | Re: list tablespaces named in custom format dump |
| Previous Message | Rob Sargent | 2022-05-23 18:31:15 | Re: list tablespaces named in custom format dump |