"Thomas F. O'Connell" <tf@xxxxxxxxxxxxxx> 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
