| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Losing data |
| Date: | 2008-06-19 15:55:40 |
| Message-ID: | 1213890940.22738.22.camel@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Garry Saddington | 2008-06-19 15:55:41 | Losing data |
| Previous Message | Decibel! | 2008-06-19 15:54:31 | Re: Database design: Data synchronization |