Re: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?

["Shoaib Mir" <shoaibmir(at)gmail(dot)com>]

It shouldnt run into these problems from time to time, that kind of a scenario only happened to me once so dont know exactly how often this can happen. But a recommendation from my end will be to upgrade to the newer PostgreSQL version as you are using an old release. Also try running some disk check utlities to see if your hardware is in a good condition.

Thanks,
-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 7/27/06, aurora < aurora00(at)gmail(dot)com> wrote:

From your experience do you expect the database would run into this from
time to time that requires DBA's interventions? Is so it would become a
problem for our customers because our product is a standalone system. We
don't intend to expose the Postgre database underneath.

wy

> Try doing a REINDEX and see if you can recover all data blocks as it
> appears
> to me you have some data blocks messed up. If possible try taking the
> backup
> for your database as well.
>
> Thanks,
>



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

               http://archives.postgresql.org