PostgreSQL Backup error


#1

Hello,

Some of our databases fails to backup with error:

23:45:29 : ERROR: Failed to backup “cartoairra” 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: Dumping the contents of table “batipopulation_2012_ra” failed: PQgetCopyData() failed. pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: The command was: COPY public.batipopulation_2012_ra (gid, id, typtopo, dcomiris, typebati, nbetages, surf3d, popm2012, popa2012, popt2012, denp2012, typpop2012, idref, perciris, idbati, geom) TO stdout; ".

The error message is always the same, but not on the same table every day.

Could you help please ?


#2

Hello,

SQLBackupAndFTP uses pg_dump tool for creation PostgreSQL databases backups. Could you please try to perform a backup manually via pg_dump tool and check if it works?

Sorry for the inconvenience.