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

Quoting Owen Hartnett <owen@clipboardinc.com>:

>
> 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 <mypg_dumpfile
>

Try to use pg_restore with the following option:

  -1, --single-transaction
                           restore as a single transaction

Or psql with the following option:

  -1 ("one")      execute command file as a single transaction

Kind regards,

Peter