"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