Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore and FK constraints with large dbs - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: pg_restore and FK constraints with large dbs
Date
Msg-id Pine.LNX.4.44.0311132329340.17499-100000@peter.localdomain
Whole thread Raw
In response to pg_restore and FK constraints with large dbs  (ow <oneway_111@yahoo.com>)
Responses Re: pg_restore and FK constraints with large dbs  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Tree view 
ow writes:

> 1) dump the data only, create the table with all indexes and constraints (from
> script that has nothing to do with pg_restore), import the data. The import
> part was running for hours (14+) with no end in sight. Had to kill it.

Dump the data and the schema and it will do it in the right order.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Moving Database Directory
Next
From: ow
Date:
Subject: Re: pg_restore and FK constraints with large dbs