Re: pg_restore and FK constraints with large dbs

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore and FK constraints with large dbs
Date: 2003-11-13 22:30:02
Message-ID: Pine.LNX.4.44.0311132329340.17499-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmx(dot)net

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ajay Prabhakar 2003-11-13 22:45:27 Modify a database user
Previous Message Peter Eisentraut 2003-11-13 22:06:17 Re: Moving Database Directory