Re: UpGrading to 7.1.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: UpGrading to 7.1.2
Date
Msg-id 29954.997386215@sss.pgh.pa.us
Whole thread Raw
In response to UpGrading to 7.1.2  ("Brian C. Doyle" <bcdoyle@mindspring.com>)
Responses Re: UpGrading to 7.1.2  ("Brian C. Doyle" <bcdoyle@mindspring.com>)
List pgsql-general
"Brian C. Doyle" <bcdoyle@mindspring.com> writes:
> Okay here is the problem this database no longer exist  At some point the
> dir path for it got removed and I do not know when or why I did that with
> out dropdb.  So postgres is still thinking it should be there.

> How do I get postgres to stop thinking it is there

DELETE FROM pg_database WHERE datname = 'foo';

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Finn
Date:
Subject: Feature request for 7.x
Next
From: newsreader@mediaone.net
Date:
Subject: FATAL 1