Thread: Where is my database gone ?
My database coraux isn't listed anymore when i use psql -l, altough i can still connect to it using psql coraux, but there isn't any tables listed by \dt. Files are still present in $PGDATA, with their content. What's the problem, and how can i recover it ? -- -- Guillaume Rousse ******************************************* Iremia - Universit� de la R�union 15 avenue Ren� Cassin, BP 7151 97715 Saint Denis, messagerie cedex 9 Tel:0262938287 Fax:0262938260 ICQ:10756815 Mail:Guillaume.Rousse@univ-reunion.fr BRIDGEKEEPER: What... is the air-speed velocity of an unladen swallow? ARTHUR: What do you mean? An African or European swallow?
Guillaume Rousse wrote: > My database coraux isn't listed anymore when i use psql -l, altough i can still > connect to it using psql coraux, but there isn't any tables listed by \dt. > Files are still present in $PGDATA, with their content. > What's the problem, and how can i recover it ? Most likely cause is that either the user that created the database does not exist anymore or your permissions got messed up somehow. I've seen similar behaviour when the user does not exist. You can see who owns the tables by doing select relname,relowner from pg_class; Then do select * from pg_user to figure out which user the relowner corresponds to. If the user is missing, create a enw one with the required uid. Adriaan
Looks like an entry in pg_user/pg_shadow is missing. Check the tables pg_user and pg_database and see if the database owner has a corresponding entry. On 2000-01-10, Guillaume Rousse mentioned: > My database coraux isn't listed anymore when i use psql -l, altough i can still > connect to it using psql coraux, but there isn't any tables listed by \dt. > Files are still present in $PGDATA, with their content. > What's the problem, and how can i recover it ? > -- -- > Guillaume Rousse > ******************************************* > Iremia - Université de la Réunion > 15 avenue René Cassin, BP 7151 > 97715 Saint Denis, messagerie cedex 9 > Tel:0262938287 Fax:0262938260 ICQ:10756815 > Mail:Guillaume.Rousse@univ-reunion.fr > > BRIDGEKEEPER: What... is the air-speed velocity of an unladen swallow? > ARTHUR: What do you mean? An African or European swallow? > > > ************ > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden