Обсуждение: What could be the problem?

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.

> [r-gonzal@uniandes.edu.co]
>
> To get back the information was necessary to recover the backup we had made
> the night before and recompile Postgres.

Sounds like this could be a shared library problem.  ldd your old postgres
binary and check (whether any|which) of the relevant libs have been upgraded
after its compilation.

--
Tomas Szepe <szepe@pinerecords.com>