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