Skip to main content

hello, we have postgres cluster that fails with the next error:

"PostgreSQL Database: [-postgres-] Data Backup Failed with PostgreSQL Error: [pg_dump: warning: tnere are circuar toreign-key constraints on this table: pg_dump: nodes pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints. pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem."

I thought commvault already uses full dump to backup.

Hello @arik 

Can you confirm the OS version and PostgreSQL version and CV version?

if you are running PostgreSQL 16 on windows server 2022 it is not supported unless you are above CV version 34 and above. The error you are seeing occurs when running that situation is why i ask. 

 

Kind regard

Albert Williams


Hi @arik 

It appears to be DB side error/warning, can you check if below link helps?

 

https://www.postgresql.org/message-id/SA0PR15MB3933C769FD7FDA12296EBD4382589%40SA0PR15MB3933.namprd15.prod.outlook.com


Hello @Albert Williams 

Its a postgres 12 running on a linux machine


Hello @arik 

I would explore what @CV_GK  has said in the above comment and if not luck a support ticket would be the next steps.

 

Kind regards

Albert Williams


Reply