Skip to main content
Question

dumpbbased backup postgres

  • 29 September 2024
  • 4 replies
  • 27 views

Forum|alt.badge.img+6

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.

4 replies

Forum|alt.badge.img+15

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


CV_GK
Vaulter
Forum|alt.badge.img+2
  • Vaulter
  • 16 replies
  • September 30, 2024

Forum|alt.badge.img+6
  • Author
  • Byte
  • 21 replies
  • September 30, 2024

Hello @Albert Williams 

Its a postgres 12 running on a linux machine


Forum|alt.badge.img+15

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings