Re: pg_restore and create FK without verification check

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: pg_restore and create FK without verification check
Дата
Msg-id 3FC47BDB.9060404@pse-consulting.de
обсуждение исходный текст
Ответ на pg_restore and create FK without verification check  (ow <oneway_111@yahoo.com>)
Ответы Re: pg_restore and create FK without verification check  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-hackers
ow wrote:

>
>It appears there's not a lot of interest in discussing the possibility of FK
>constraint creation WITHOUT the verification check. How then should one handle
>the situation with pg_restore and large dbs where creation of FK constraint(s)
>may take hours?
>  
>

I'd prefer a backup/restore method that dumps physical data, so at 
restore time there's no need for recreation of FKs. But I didn't see any 
feedback on this proposal either.

Regards,
Andreas




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hans-Jürgen Schönig
Дата:
Сообщение: statistics about tamp tables ...
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: pg_restore and create FK without verification check