Re: pg_restore and FK constraints with large dbs - Mailing list 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