inconsistent backup?

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: "General, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: inconsistent backup?
Date: 2013-12-19 08:41:59
Message-ID: 1421748325.281034.1387442519939.JavaMail.open-xchange@ox.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Version: 9.2

Regards, akretschmer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wd 2013-12-19 09:27:52 Re: unexpected pageaddr error in db log
Previous Message Chris Travers 2013-12-19 07:52:26 Re: Multi Master Replication