Re: What could be the problem?

"Rafael Mauricio González Palacios" <r-gonzal(at)uniandes(dot)edu(dot)co> wrote:
> Hello.
>
> We had a very serious trouble last week with our databases in Postgres and
we
> wanna know if maybe someone can help us to find the problem.
>
> The trouble was that a day some databases in Postgres appear without any
row
> of information; some other, doesn't led us describe the tables (\d), or
list
> the data bases (\l), or when we try to run an invalid command Postgres
gave us
> a 'segmentation fault' message.

Did you had power failure recently ?

> To get back the information was necessary to recover the backup we had
made
> the night before and recompile Postgres.
>
> We have Postgres 7.1.1. and Red Hat 7.2

Try to upgrade to Postgres 7.3.3 you'll not find the RPM for RH 7.2
but look this my recent post:
http://archives.postgresql.org/pgsql-admin/2003-05/msg00409.php

Regards
Gaetano Mendola