Tom,
Thank you This is what I was looking for. Unfortunately for me I took the
advice of the others who wrote and manually backed up each db
seperately. But from here on out I will know as well as everyone else on
the list.
Again Thank you Tom
At 03:43 PM 8/9/01 -0400, Tom Lane wrote:
>"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
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html