The following bug has been logged online:

Bug reference: 2526
Logged by: wee goh
Email address: glorydental (AT) yahoo (DOT) com
PostgreSQL version: 8.0.3-2
Operating system: linux
Description: records lost
Details:

i discovered records in my postgresql database missing every 6 - 8 months. i
supsect those not updated or amended are the ones that are gone, still
wondering the real reason behind ? i doubt is lack of vaccum as my
transactions are minnimal, inserting about 200 records each month and
updating about 1000 records each month.

this happens with previous versions of postgresql as well.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Wed, Jul 12, 2006 at 08:58:43PM +0000, wee goh wrote:
How much querying are you doing? Are you vacuuming at all? What's
the output of the following command?

SELECT datname, age(datvacuumxid) AS vage, age(datfrozenxid) AS fage
FROM pg_database;

Do the server logs contain any unusual messages? Have you had any
hardware problems or system crashes?

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org