Re: Losing data from Postgres

* Paul Breen <pbreen(at)computerpark(dot)co(dot)uk> [001115 07:46] wrote:
> Hello everyone,
>
[snip]
>
> Recently we have discovered that some records are missing from the main
> database table on the master box but are present in the table on the
> spare. We know its not a transaction problem (rolling back on master but
> not spare) because reports printed at the time of the records being
> written show the data in the master. It seems that some time afterwards
> the records just disappear from the master! Both boxes are raided (Raid
> 5), don't know if this is significant.
>
[snip]
>
> We are using Postgres version 6.5.3. I know its old but this is the
> customer standard and we are loathe to upgrade unless its a problem
> inherent with this version. From a cost-of-ownership viewpoint, its
> easier to support a single version than multiple versions. The OS is SuSE
> Linux 6.3 (kernel 2.2.13), the control system programs talk to Postgres
> via libpq, the web interface is PHP3 and the Tcl/Tk interface is pgtksh.
> The Raid controller is a DPT SmartCache 4 (28 MB RAM). Both the master
> and the spare boxes are Intel Pentium III 550Mhz with 256MB RAM.

My suggestion would be to try the latest version, 7.0.3, it's fixed
numerous bugs for us and performs a lot better. We used to have a
bunch of problems with 6.5.3 and upgrading to 7.0.2 solved a lot
of them, 7.0.3 solved the rest of the problems we've seen in 7.0.2.

best of luck,
-Alfred