Message-ID: <73f2a5f02921062ef1fe00bc07b4e431d7a8826f.camel@cybertec.at>
Subject: Re: Incompatibility of newest pg_restore with PostgreSQL-Servers
 older or equal to version 16
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: combit - Nicolaij =?ISO-8859-1?Q?Deutschk=E4mer?=
	 <Deutschkaemer@combit.net>, "pgsql-bugs@lists.postgresql.org"
	 <pgsql-bugs@lists.postgresql.org>
Date: Wed, 18 Dec 2024 15:25:40 +0100
In-Reply-To: <f05029addfa34fab9c06140779f38fc9@combit.net>
References: <f05029addfa34fab9c06140779f38fc9@combit.net>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.2 (3.54.2-1.fc41) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/73f2a5f02921062ef1fe00bc07b4e431d7a8826f.camel%40cybertec.at>
Precedence: bulk

On Wed, 2024-12-18 at 10:05 +0000, combit - Nicolaij Deutschk=C3=A4mer wrot=
e:
> we are currently facing an issue regarding the usage of the latest pg_res=
tore.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 =E2=80=94 not even if the dump was ta=
ken
   from a server of that version."

Yours,
Laurenz Albe