"Phoenix Kiula" <phoenix.kiula@xxxxxxxxx> writes: > Hello. I have a database dump. With data and schema, which includes > all the constraints and rules. But it seems the pg_dumpall command > does not copy data in such a way that foreign keys are satisfied upon > restoring. Because tables are inter-related, importing them keep > giving errors and eventually no data is imported. This shouldn't be possible in a regular dump, at least not with any remotely modern version of PG. However, if you are trying to restore a data-only dump into an already-created set of tables, it is possible because pg_dump doesn't know how to order the data loads in that case. (The problem may in fact be insoluble, since circular foreign key relationships are allowed.) The recommended solution is to use a regular schema-and-data dump. If you really have to separate schema and data, the --disable-triggers switch might help, though you open yourself to the possibility of loading inconsistent data that way. regards, tom lane
