Quoting Owen Hartnett <owen@xxxxxxxxxxxxxxxx>:
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
