Re: Losing data from Postgres

Bonjour Paul Breen
>
> Hello everyone,
>
> Can anyone help us?
>
> We are using Postgres in a hotspare configuration, that is, we have 2
> separate boxes both running identical versions of Postgres and everytime
> we insert|update|delete from the database we write to both boxes (at the
> application level). All communications to the databases are in
> transaction blocks and if we cannot commit to both databases then we
> rollback.
[...]
> Originally we were vacuuming twice a day but because some of the reports
> we produce regularly were taking too long as the database grew, we added
> multiple indexes onto the key tables and began vacuuming every hour. It's
> only after doing this that we noticed the data loss - don't know if this
> is coincidental or not. Yesterday we went back to vacuuming only twice a
> day.

We found something similar on our application.
Seems to be a vacuum+index problem, the index do
not refer to ALL data after the vacuum!.

If I am right, drop the index, create the index again
and your data should be found again...

On our side now, before to do vacuum we drop the index
do vacuum, rebuild the index. The overall time is
the same as doing a 'simple' vacuum.

Hoping that help...

A bientot
==========================================================================
Jean-Marc Pigeon Internet: Jean-Marc(dot)Pigeon(at)safe(dot)ca
SAFE Inc. Phone: (514) 493-4280 Fax: (514) 493-1946
REGULUS, a real time accounting/billing package for ISP
REGULUS' Home base <"http://www.regulus.safe.ca">
==========================================================================