Skip site navigation (1) Skip section navigation (2)

Database Corruption, Tables, Databases missing

From: Alan Donald <critirc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database Corruption, Tables, Databases missing
Date: 2005-04-24 09:43:20
Message-ID: 66a4b63105042402435842a8e4@mail.gmail.com (view raw or flat)
Thread:
Lists: 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 ?

Responses

pgsql-admin by date

Next:From: SimpsonDate: 2005-04-24 12:54:50
Subject: postmaster stop hangs
Previous:From: Tom LaneDate: 2005-04-24 00:12:44
Subject: Re: FW: PostgreSQL (real and effective user ids must match) error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group