2009/4/1 Patrick Desjardins <mrdesjardins@xxxxxxxxx>:
> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
