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