On Tuesday 12 May 2009 2:35:10 pm Vasiliy Vasin wrote: > In the end, decided to make easier: make a complete dump except tables that > I don't want to backup, then just dump schema of these tables. So I have 2 > files: schema+data for all except table1 and table2, schema only for table1 > and table2. It's a strangely that pg_restore is still no option to check > the constraints after you insert all data. Something like > http://www.postgresql.org/docs/8.3/static/sql-set-constraints.html It is more of a conceptual problem. Unless you really do a complete dump (which you actually did not do above) then the schema and data become decoupled. A less than complete restore could be any combination of data and schema from various points in time. A partial pg_restore has no way of "knowing" what is correct, therefore it is left for the user to decide correctness. > > 13.05.09, 01:17, "Adrian Klaver" <aklaver@xxxxxxxxxxx>: > > Sounds like an ordering problem, you are restoring the child table before > > the parent. Best bet is to dump the table data to individual files and > > restore them in the proper order. -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
