Обсуждение: Database Corruption, Tables, Databases missing

Поиск
Список
Период
Сортировка

Database Corruption, Tables, Databases missing

От
Alan Donald
Дата:
I have a few databases running on a postgres database server.

Everything was working fine and then yesterday when I logged in, there
were a few databases that are missing. These tables cannot be seen in
the pg_database table. Also I cannot see these tables via pg_admin and
understandable so.

Please tell me what the issue is, why it is happening and how I can I
restore the database.
What do I need to do to make sure that this does not happen in the future ?

Re: Database Corruption, Tables, Databases missing

От
Michael Fuhr
Дата:
On Sun, Apr 24, 2005 at 03:43:20PM +0600, Alan Donald wrote:
>
> I have a few databases running on a postgres database server.
>
> Everything was working fine and then yesterday when I logged in, there
> were a few databases that are missing. These tables cannot be seen in
> the pg_database table. Also I cannot see these tables via pg_admin and
> understandable so.

Are you doing regular database-wide vacuums?  What's the result of
the following query?

SELECT datname, age(datvacuumxid), age(datfrozenxid) FROM pg_database

> Please tell me what the issue is, why it is happening and how I can I
> restore the database.

Without more information it's hard to say, but you might have
encountered transaction ID wraparound; the above query should answer
that question.  See the "Routine Database Maintenance Tasks" chapter
in the documentation for more info.

Is it possible that the databases were dropped?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/