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
13.05.09, 01:17, "Adrian Klaver" <akla...@comcast.net>: > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
