Re: What could be the problem? - Mailing list pgsql-admin

From Mendola Gaetano
Subject Re: What could be the problem?
Date
Msg-id 003001c32e76$c56c17c0$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to What could be the problem?  (Rafael Mauricio González Palacios<r-gonzal@uniandes.edu.co>)
List pgsql-admin
"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



pgsql-admin by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: Diagnose Database Corruption
Next
From: Michael A Nachbaur
Date:
Subject: Syncing DBs prior to RServ replication