PostgreSQL 12 issue

Michael_Highguy · October 29, 2019, 12:45pm

10/29/2019 12:35:42 PM [Error] Failed to backup “postgres” 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: server version: 12.0 (Ubuntu 12.0-2.pgdg18.04+1); pg_dump version: 11.1
pg_dump: aborting because of server version mismatch”.

Alexander · October 31, 2019, 10:10am

Hi Michael_Highguy,

To resolve the issue, could you please go to the “Connect to Server” window and specify the path to your PostgreSQL bin folder at the “Advanced settings”?

SQLBackupAndFTP

Sorry for the inconvenience.

Michael_Highguy · November 5, 2019, 8:53am

Thank you very much for replay.
Do you plan to fix it in advanvce?

Michael_Highguy · November 5, 2019, 1:08pm

Here is what I did:

We are using the remote windows backup server to backup instances from Linux machines
I just downloaded the zip package of postgres and took the bin directory to any place and provided that directory in advanced tab of connection
After that I tried to backup and got

11/5/2019 12:55:32 PM [Error] Failed to backup “postgres” database with “Full” backup type: C:\Users\michael.hi\Downloads\postgresql-12.0-1-windows-x64-binaries\pgsql\bin\pg_dump.exe process has finished with “1” code. The error message: “C:\Users\michael.hi\Downloads\postgresql-12.0-1-windows-x64-binaries\pgsql\bin\pg_dump.exe: illegal option – oids
Try “pg_dump --help” for more information.”.

I unticked the object identifiers option and everything worked like a charm.

The question is: is it the bug or feature

Alexander · November 7, 2019, 3:34pm

Hi Michael_Highguy,

Yes, this is the feature. We have added this parameter to avoid the issue when some versions of pg_dump support this parameter and some do not.

ak1 · December 26, 2019, 12:18pm

any solution please! same error

Alexander · December 27, 2019, 1:26pm

Hi ak1,

That issue was fixed in the latest release of SQLBackupAndFTP - version 12.2.11 https://sqlbackupandftp.com/download Could you please install it and check if it works?

Sorry for the inconvenience.

ak1 · December 30, 2019, 12:03pm

hi Alexander
i have 12.2.11…
30.12.2019 13:42:55 [Error] Failed to backup “ABC” database with “Full” backup type: C:\Program Files\PostgreSQL\12\bin\pg_dump.exe process has finished with “1” code. The error message: “C:\Program Files\PostgreSQL\12\bin\pg_dump.exe: illegal option – oids
Try “pg_dump --help” for more information.”.

Alexander · January 2, 2020, 10:24am

Hi ak1,

To resolve the issue, please go to the “PostgreSQL Backup Options” window and disable the “Dump object identifiers (OIDs)” option.

Sorry for the inconvenience.