Re: Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16 - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
Date
Msg-id 73f2a5f02921062ef1fe00bc07b4e431d7a8826f.camel@cybertec.at
Whole thread Raw
List pgsql-bugs
On Wed, 2024-12-18 at 10:05 +0000, combit - Nicolaij Deutschkämer wrote:
> we are currently facing an issue regarding the usage of the latest pg_restore.exe from V17
> with PostgreSQL-Servers older or equal to version 16.

You cannot use pg_restore from v17 to restore into a v16 server.

In https://www.postgresql.org/docs/current/app-pgdump.html, we have:

  "Also, it is not guaranteed that pg_dump's output can be loaded into
   a server of an older major version — not even if the dump was taken
   from a server of that version."

Yours,
Laurenz Albe



pgsql-bugs by date:

Previous
From: Tomasz Szypowski
Date:
Subject: RE: Not able to restore database - error: could not decompress data: Allocation error : not enough memory
Next
From: Tom Lane
Date:
Subject: Re: Not able to restore database - error: could not decompress data: Allocation error : not enough memory