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?
