pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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