Wonderful news.

I just ran dump and restore against same production server. Constraints and the absence of drop <object> calls appears to have saved my butt.

Tom Lane wrote:
Rob Sargent <robjsarg...@gmail.com> writes:
Is there a difference in the order of execution between an ascii dump and one using the "custom" format? Or any difference in the general operation?

There's not supposed to be.  One standard test on the pg_dump code is
        pg_dump >textfile
        pg_dump -Fc >dumpfile
        pg_restore dumpfile >textfile2
        diff textfile textfile2
If these don't produce the same results something is broken.

                        regards, tom lane

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to