Re: pg_dump restore as transaction?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:37:52
Message-ID: 23350.1228153072@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Owen Hartnett <owen(at)clipboardinc(dot)com> writes:
> 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?

That's correct, and intentional. You can use pg_restore's -1 switch
or add begin/end manually if you don't want it to work that way.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-01 17:40:02 Re: pg_dump restore as transaction?
Previous Message Peter Billen 2008-12-01 17:36:24 Re: pg_dump restore as transaction?