From: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Rows missing from table despite FK constraint |
Date: | 2010-01-07 10:12:24 |
Message-ID: | 6645f6441001070212h51919077rea8ae68e44683f71@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
We use PG 8.3. We use pg_dump and pg_restore overnight to create
copies of main database for reporting etc. One dump/restore runs at 9
PM, another at 11 PM.
Today I discovered that the restore at 11 PM failed to recreate a
foreign key constraint, because one row from master table was missing.
It is also missing from main database, but not from the 9 PM dump.
The main database is in curious state: The row from master table is
missing, the row referencing it from slave table is present, and
finally the FK constraint on slave is in place.
Do you have any ideas on how it could possibly happen? What research
could help find the root cause and fix the database?
Thanks.
--
Konrad Garus
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2010-01-07 10:29:50 | Re: PostgreSQL Write Performance |
Previous Message | Vincenzo Romano | 2010-01-07 09:17:46 | A maybe-bug? |