Search Postgresql Archives

Re: Losing data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Friday 20 June 2008 05:26, Robert Treat wrote:
> 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?
We back up and vacuum at the same time each day.
garry


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux