Re: A Haunted Database - Mailing list pgsql-general

From Ed Loehr
Subject Re: A Haunted Database
Date
Msg-id 38EF9D87.EA4E9C74@austin.rr.com
Whole thread Raw
In response to A Haunted Database  ("Robert Cleveland" <rob.cleveland@wardsauto.com>)
List pgsql-general
Robert Cleveland wrote:
>
> ... Then , in the middle of the night, something happens and when
> we awake, we find the HTML has been scrambled like so many breakfast eggs.
> ... Does anyone know what inhuman entity
> might be causing this to occur?

Hmmm...hard not to yell, "It's GREMLINS!!!"...

I'd put a trigger on the table to log the date/time of any changes to the
server log.  That might tell you if it's getting corrupted via SQL or via
file system access.  Or you might just shutdown the server and see if it
still gets corrupted (verifying your assertion that nobody is touching the
db).

Regards,
Ed Loehr

pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: oid dependency question...
Next
From: Peter Eisentraut
Date:
Subject: Re: Changes doc for 7.0 beta 4?