| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
| Subject: | Re: Losing data |
| Date: | 2008-06-20 04:26:16 |
| Message-ID: | 200806200026.16387.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
> > In any case, however, if PostgreSQL reported the transaction complete and
> > the machine didn't experience any hardware problems (like sudden power or
> > disk failure), I would certainly not suspect PostgreSQL as the source of
> > the problem.
>
> What has happened to the reports then? I have used this combination of Zope
> and Postgres for 5 years with no problems like this before and we have
> written one complete set of reports on this server in the past 6 weeks. The
> problem seems to have started last friday, when reports started to go
> missing.
Out of curiosity, what is your vacuum strategy?
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-06-20 04:49:13 | Re: Losing data |
| Previous Message | Adrian Klaver | 2008-06-20 00:35:03 | Re: Importing undelimited files (Flat Files or Fixed-Length records) |