Re: Losing data

On Thu, Jun 19, 2008 at 9:55 AM, Garry Saddington
<garry@schoolteachers.co.uk> wrote:
> I have had a serious loss of data and wondered if anyone could shed any light
> on what may have happened.
> My users have been writing reports on students. No error messages have been
> produced and when called back up the reports seem to be present at the time
> of writing. However, next day they have disappeared, and they do not appear
> in a pg_dump. They seem to have been kept in memory and never written to
> disk.
> We are using Zope and connecting to Postgres through psycopg on Centos 5.
> I suspect a hard disk failure but any other ideas would be welcome.
> Would these reports be in the WAL?
> regards

Just a guess, but do you have some kind of search engine pointing at
the application?  Could it be hitting a "delete" link maybe?