Re: pg_restore and FK constraints with large dbs

Поиск
Список
Период
Сортировка
От ow
Тема Re: pg_restore and FK constraints with large dbs
Дата
Msg-id 20031117182131.9679.qmail@web21403.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pg_restore and FK constraints with large dbs  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Reece Hart
Дата:
Сообщение: Re: compare two databases
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: pg_restore and FK constraints with large dbs