pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedIncompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
2+ messages / 2 participants
[nested] [flat]
* Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
@ 2024-12-18 10:05 combit - Nicolaij Deutschkämer <Deutschkaemer@combit.net>
0 siblings, 1 reply; 2+ messages in thread
From: combit - Nicolaij Deutschkämer @ 2024-12-18 10:05 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Dear Sir or Madam,
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.
Our product supports and encourages the usage of PostgreSQL servers and to facilitate the process of restoring database backups for end users we have created a wrapper with a simple GUI that calls the pg_restore executable under the Windows OS with the following commands:
set PGPASSWORD=<password>
pg_restore.exe -h -p -U -c --if-exists -d -v <pathToBackupFile>
The restore itself runs fine, however pg_restore indicates that the action may have failed, due to the fact that the option 'transaction_timeout = 0' could not be set. Since this option is new to PostgreSQL 17 and newer, this option shouldn't be set in the first place on PostgreSQL servers older than 17, eg 16.
This is the output which indicates the issue:
pg_restore: connecting to database for restore
pg_restore: while INITIALIZING:
pg_restore: error: could not execute query: FEHLER: unbekannter Konfigurationsparameter »transaction_timeout«
Command was: SET transaction_timeout = 0;
Kind regards
Nicolaij Deutschkämer
[cid:logo]
combit GmbH
Bücklestr. 3-5
78467 Konstanz
Deutschland
T +49 7531 9060-10
F +49 7531 9060-18
deutschkaemer@combit.net<mailto:deutschkaemer@combit.net>
www.combit.net<https://www.combit.net;
Geschäftsführer: Björn Eggstein, Jochen Bartlau, Brita Dannenmann
Handelsregister: Amtsgericht Freiburg HRB 380959
Umsatzsteuer-Identifikationsnummer: DE 142311808
Informationen zur Verarbeitung Ihrer personenbezogenen Daten erhalten Sie in unseren Datenschutzhinweisen<https://www.combit.net/impressum/#Datenschutz;.
Attachments:
image001.png (image/png, 10.9K) download
view image
* Re: Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
@ 2024-12-18 14:25 Laurenz Albe <laurenz.albe@cybertec.at>
parent: combit - Nicolaij Deutschkämer <Deutschkaemer@combit.net>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2024-12-18 14:25 UTC (permalink / raw)
To: combit - Nicolaij Deutschkämer <Deutschkaemer@combit.net>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-12-18 14:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-12-18 10:05 Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16 combit - Nicolaij Deutschkämer <Deutschkaemer@combit.net>
2024-12-18 14:25 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox