| From: | Ralf Schuchardt <rasc(at)gmx(dot)de> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | "General, Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: inconsistent backup? |
| Date: | 2013-12-19 10:09:42 |
| Message-ID: | 129E7FF8-10F4-459F-8301-05B9061478B6@gmx.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>:
> hello all,
>
> don't ask why, but a customer created tables with foreign key constraints but
> with inconsistent data.
>
> Because of this he disabled all triggers (alter table foo disable trigger all).
> So far, so bad ...
> (he can't clean the data at the moment)
>
> In the dump there are the constraints, but NOT the disable triggers. In other
> words: no way to restore.
>
> What can we do now?
pg_restore has a --disable-triggers option, that could be of some help. Or you add the command to the top of the sql dump file.
Ralf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurentius Purba | 2013-12-19 14:07:25 | Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3? |
| Previous Message | wd | 2013-12-19 09:27:52 | Re: unexpected pageaddr error in db log |