Thread: What could be the problem?

What could be the problem?

From
Rafael Mauricio González Palacios
Date:
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.

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

We thanks any help you can give us.

Sincerely,

Mauricio.

Re: What could be the problem?

From
"Mendola Gaetano"
Date:
"Rafael Mauricio González Palacios" <r-gonzal@uniandes.edu.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