From: combit - Nicolaij Deutschkämer <Deutschkaemer@combit.net>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
Date: Wed, 18 Dec 2024 10:05:17 +0000
Message-ID: <f05029addfa34fab9c06140779f38fc9@combit.net> (raw)
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) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: Deutschkaemer@combit.net, pgsql-bugs@lists.postgresql.org
Subject: Re: Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16
In-Reply-To: <f05029addfa34fab9c06140779f38fc9@combit.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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