Re: A Haunted Database

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Robert Cleveland <rob(dot)cleveland(at)wardsauto(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A Haunted Database
Date: 2000-04-08 20:58:47
Message-ID: 38EF9D87.EA4E9C74@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-04-09 01:31:58 Re: granting permission to groups?
Previous Message Charles Tassell 2000-04-08 19:54:20 Re: A Haunted Database