The following bug has been logged online: Bug reference: 2526 Logged by: wee goh Email address: [EMAIL PROTECTED] 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