2009/4/1 Patrick Desjardins <mrdesjardins(at)gmail(dot)com>:
> We are using EnterpriseDB PostGresql 8.3. I can't simply take a good backup
> because weeks have pass since the first error occurs.
>
> I will try to Vacumm Full first, if nothing is fixed, I will try to pg_dump
> like you suggest.
>
In 7.x versions, i declare a var in postgresql.conf (zero_damaged_pages = on )
and make the dump with this option. I don't know if this var is in newly
versions.
Did you try to make a reindex?
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arpug.com.ar)
ArPUG / AOSUG Member
Postgresql Support & Admin