| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | ow <oneway_111(at)yahoo(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_restore and FK constraints with large dbs |
| Date: | 2003-11-18 14:44:19 |
| Message-ID: | 200311181444.hAIEiJZ01768@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
ow wrote:
>
> --- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jérôme Kestener | 2003-11-18 15:15:16 | Replicate PostgreSQL with rsync |
| Previous Message | Andrew Sullivan | 2003-11-18 14:29:19 | Re: [GENERAL] Point-in-time data recovery - v.7.4 |