Quoting Owen Hartnett <owen(at)clipboardinc(dot)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