Hi, I'm trying to make a backup of a Mezzanine site database before attempting an upgrade but get this error from pg_dump:
(I've tried using all formats; tar, custom, directory, sql) pg_dump: NOTICE: there are circular foreign-key constraints among these table(s): pg_dump: pages_page 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. pg_dump: NOTICE: there are circular foreign-key constraints among these table(s): pg_dump: generic_threadedcomment 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 know this isn't strictly a Mezzanine issue but google-fu just shows lots of convoluted faffing with temporary tables for the restore, etc and others stating that pg_dump with a binary format will never have this issue....I'm feeling like there must be an easy way to take a full backup/clone of a database but after many hours I just can see it. Can anyone here help with this? Paul -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
