Owen Hartnett wrote: > If my perusal of the sql generated by pg_dump is correct, then it > doesn't appear that it's wrapped in a transaction, and thus might be > able to only complete a partial restore?
You're right, it is not. Try pg_restore --single-transaction. (You'll need pg_dump -Fc though.) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
