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

From ow
Subject Re: pg_restore and FK constraints with large dbs
Date
Msg-id 20031117182131.9679.qmail@web21403.mail.yahoo.com
Whole thread Raw
In response to Re: pg_restore and FK constraints with large dbs  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-admin
--- Rudi Starcevic wrote:

> I'm not trying to upset anyone just trying to help you get an answer for your

> issues.

Who knows what you're trying to do? You did not provide any answers and why you
decided to quote the *same* email *twice* if it was sent only *once* I may
never know.

Anyway, that's not important. What important is that there's no way to suspend
FK checks when restoring a database. Depending on the size of the database, FK
checks alone may add hours or maybe even days to the time that's otherwise
would be necessary to run pg_restore. People with large dbs should be aware of
that.

If one needs to suspend FK checks during db import one may have to consider
another RDBMS ... like mySql, for example.





__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

pgsql-admin by date:

Previous
From: Reece Hart
Date:
Subject: Re: compare two databases
Next
From: Stephan Szabo
Date:
Subject: Re: pg_restore and FK constraints with large dbs