Re: pg_restore and FK constraints with large dbs

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_restore and FK constraints with large dbs
Дата
Msg-id 200311181444.hAIEiJZ01768@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_restore and FK constraints with large dbs  (ow <oneway_111@yahoo.com>)
Ответы Re: pg_restore and FK constraints with large dbs
Список pgsql-admin
ow wrote:
>
> --- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> >
> > Yep, we want to do something, but not sure what.  We have:
> >
> >     * Allow triggers to be disabled [trigger]
> >
>
> Will ppl remember some time from now that it also deals with FK constraints and
> pg_restore/dump options?

We probably need a multi-option approach, where you can disable all
triggers, constraints, and foreign keys depending on your needs.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [GENERAL] Point-in-time data recovery - v.7.4
Следующее
От: ow
Дата:
Сообщение: Re: pg_restore and FK constraints with large dbs