At 12:37 PM -0500 12/1/08, Tom Lane wrote:
Owen Hartnett <[EMAIL PROTECTED]> 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 intentiona
Quoting Owen Hartnett <[EMAIL PROTECTED]>:
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?
Or does
psql myDatabase
Try to use pg_restore with the following opti
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 t
Owen Hartnett <[EMAIL PROTECTED]> 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
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?
Or does
psql myDatabase If not, is there a reason why it can't be done so (some process that
cannot be run as a tra
