pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database Corruption, Tables, Databases missing
2+ messages / 2 participants
[nested] [flat]

* Database Corruption, Tables, Databases missing
@ 2005-04-24 09:43  Alan Donald <critirc@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Alan Donald @ 2005-04-24 09:43 UTC (permalink / raw)
  To: pgsql-admin

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 ?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Database Corruption, Tables, Databases missing
@ 2005-04-24 13:30  Michael Fuhr <mike@fuhr.org>
  parent: Alan Donald <critirc@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2005-04-24 13:30 UTC (permalink / raw)
  To: Alan Donald <critirc@gmail.com>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-24 13:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-24 09:43 Database Corruption, Tables, Databases missing Alan Donald <critirc@gmail.com>
2005-04-24 13:30 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox