Re: [GENERAL] Where is my database gone ?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Guillaume Rousse <Guillaume(dot)Rousse(at)univ-reunion(dot)fr>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] Where is my database gone ?
Date: 2000-01-12 01:47:25
Message-ID: Pine.LNX.4.21.0001120239050.3735-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)Rousse(at)univ-reunion(dot)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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-01-12 01:47:39 Re: [GENERAL] Inheritance and primary key
Previous Message Alain TESIO 2000-01-12 01:09:10 Re: [GENERAL] How do you live without OUTER joins?