On Thursday 19 June 2008 18:09, Scott Marlowe wrote: > On Thu, Jun 19, 2008 at 9:55 AM, Garry Saddington > > <garry@xxxxxxxxxxxxxxxxxxxx> 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? Don't think so, once a teacher has entered a report there is no way that they can delete it. Regards Garry
