On Wednesday 29 April 2009, "Michele Petrazzo - Unipex" <michele.petra...@unipex.it> wrote: > The unique solution that I found it's that to export with pg_dump all my > tables except the table_three and, after, exporting only that and on the > other host and import that alone... > > It's this a normal behavior, a "missing feature", or...?
pg_dump and pg_restore correctly backup and restore complete databases. Partial backups and restores work, but of course can create expected dependency problems that only the operator is in a position to resolve. In your case you restored the complete schema and then tried to import data, which failed due to a foreign key constraint. In a full backup and restore, all the table data would have been restored prior to that constraint being created. -- Even a sixth-grader can figure out that you can’t borrow money to pay off your debt -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
