Re: pg_dump restore as transaction?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Owen Hartnett <owen(at)clipboardinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump restore as transaction?
Date: 2008-12-01 17:40:02
Message-ID: 20081201174002.GG4459@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Owen Hartnett 2008-12-01 17:46:18 Re: pg_dump restore as transaction?
Previous Message Tom Lane 2008-12-01 17:37:52 Re: pg_dump restore as transaction?