Hi,
Trying to backup PostgreSQL version 17 results with error:
Failed to backup “aaa” database with “Full” backup type: C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql\pg_dump.exe process has finished with “1” code. The error message: “pg_dump: error: aborting because of server version mismatch pg_dump: detail: server version: 17.0; pg_dump version: 16.0”.
1 Like
Hello Asaf,
Thank you for your message.
To resolve the issue, please go to the advanced settings of your connection window and specify the path to your PostgreSQL bin folder:
Regards,
Oleg
1 Like
This solution only works if PostgreSQL 17 is installed on the computer where the backup/restore is being performed. In our environment that isn’t the case, so this won’t work.
Same here as [Greg_Lamberson].
Also copying the latest pg_dump.exe from PgAdmin to replace pg_dump in SQLBackupAndFTP installation folder also does not work
Any plan for the next release?
Thanks
Hello,
Thank you for your message.
Simply replacing pg_dump.exe in the SQLBackupAndFTP installation folder may not work because there might be dependencies on other files.
You can install PostgreSQL directly from the official website: PostgreSQL: Windows installers
During the installation, make sure to uncheck all options except for “Command Line Tools” (see the screenshot).
Once installed, point SQLBackupAndFTP to the binaries located in a path similar to: C:\Program Files\PostgreSQL\17\bin
``
``
We plan to address this issue in the next release of our application.