"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > My big question is: Is there anything that happens late in the game > in a pg_dumpall that affects system catalogs or other non-data > internals in any critical ways that would make an interrupted > pg_dumpall | psql sequence unstable?
There's quite a lot of stuff that happens after the data load, yes. One thought that comes to mind is that permissions aren't granted/revoked until somewhere near the end. But why don't you look at the output of "pg_dumpall -s" and find out for yourself what got lost? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq