On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington 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? If it was hardware related you would know, quickly. This sounds a great deal more like an application level interaction. Perhaps your zope application caches things for a while before committing to disk? Are you familiar with the actual database itself? Have you checked the database logs for errors? Sincerely, Joshua D. rae
