inconsistent backup? - Mailing list pgsql-general

From Andreas Kretschmer
Subject inconsistent backup?
Date
Msg-id 1421748325.281034.1387442519939.JavaMail.open-xchange@ox.ims-firmen.de
Whole thread Raw
Responses Re: inconsistent backup?  (Ralf Schuchardt <rasc@gmx.de>)
List 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


pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Multi Master Replication
Next
From: wd
Date:
Subject: Re: unexpected pageaddr error in db log