Re: Interrupted pg_dump / pg_restore Upgrade

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