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