Re: pg_dump restore as transaction? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_dump restore as transaction?
Date
Msg-id 20081201174002.GG4459@alvh.no-ip.org
Whole thread Raw
In response to pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump restore as transaction?
Next
From: Peter Billen
Date:
Subject: Re: pg_dump restore as transaction?