The error message: pg_dump: warning: WITH OIDS is not supported anymore

Hello! I use SQLBackupAndFTP to backup three PostgreSQL databases, but I get a message while backup first database:

06.04.2021 22:07:52 [Error] Failed to backup “upp” 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: warning: WITH OIDS is not supported anymore (table “_yearoffset”)
pg_dump: warning: WITH OIDS is not supported anymore (table “config”)
pg_dump: warning: WITH OIDS is not supported anymore (table “configsave”)
pg_dump: warning: WITH OIDS is not supported anymore (table “dbschema”)
pg_dump: warning: WITH OIDS is not supported anymore (table “files”)
pg_dump: warning: WITH OIDS is not supported anymore (table “ibversion”)
pg_dump: warning: WITH OIDS is not supported anymore (table “params”)
pg_dump: error: Dumping the contents of table “config” failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: invalid memory alloc request size 1308544571
pg_dump: error: The command was: COPY public.config (filename, creation, modified, attributes, datasize, binarydata) TO stdout;”.

What does this error mean? How can I fix it?

Hi Evgeny,

Unfortunately, we truncate long error messages. Could you please enable the Advanced Log with the trace level, reproduce the issue and look for this error there, usually somewhere at the end of messages from pg_dump there will be a message that indicates a specific problem?

Sorry for the inconvenience.