Incompatibility of newest pg_restore with PostgreSQL-Servers older or equal to version 16

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(at)combit(dot)net<mailto:deutschkaemer(at)combit(dot)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>.