"Rafael Mauricio González Palacios" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
