> We took back up of a database using the following command
> pg_dump -a
> In the back up file that was generated we found some data that was
> violating foreign key constraints. And there fore we were not able to
> restore database back with this back up file.
Was the data actually erroneous, or just loaded in the wrong order
(ie, referencing table before referenced one)? pg_dump -a doesn't
guarantee to use a safe reload order.
regards, tom lane
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
No comments:
Post a Comment