pg_dump: warning: there are circular foreign-key constraints
Opened this issue · 1 comments
floh116 commented
After Updating from postgres extension version 5.1 to version 5.2 (also install on new installation with 5.2 from the start)
pg_dump (and pg_dumpall) is printing out a warning:
[root@postgresdb02 home]# sudo -u postgres pg_dump repmgr
pg_dump: warning: there are circular foreign-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.
-- PostgreSQL database dump
-- Dumped from database version 12.5
.......
It seems this warnings came in with d62743d
loop-evgeny commented
Still happening with repmgr 5.3.3, PostgreSQL 15.2. In fact, on the primary I get:
pg_dump: warning: there are circular foreign-key constraints on this table:
... with no tables listed! On the primary it lists the table "node", as in the original issue description.