EnterpriseDB/repmgr

pg_dump: warning: there are circular foreign-key constraints

Opened this issue · 1 comments

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

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.