Re: list tablespaces named in custom format dump

On 5/23/22 10:19 AM, Rob Sargent wrote:
> On 5/23/22 11:07, Adrian Klaver wrote:
>> On 5/23/22 10:01 AM, Rob Sargent wrote:
>>> On 5/23/22 11:00, Adrian Klaver wrote:
>>>> On 5/23/22 9:54 AM, Rob Sargent wrote:
>>>>> On 5/23/22 10:50, Adrian Klaver wrote:
>>>>

>>
> This is great news.  I do have pg14.  I thought you had to dump with the
> save version as restore

pg_dump and pg_restore are backwards compatible. The recommendation is
to use the same version of pg_dump as the server you are dumping if the
plan is use it as backup to restore to same version of server. If you
are planning on restoring to newer version then use the newer version of
pg_dump to dump the older server version e.g. version 14 pg_dump dumps
version 12 Postgres server. Then use the newer version of pg_restore(14
in this case) to restore to the Postgres 14 server.

For the purposes of this question using the 14 version of pg_restore is
acceptable to get the information. Actually doing a restore to a 14
version of the server with 12 version of a dump file may create problems
as the 12 version of pg_dump may not include information needed by the
newer server.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com