UpGrading to 7.1.2

Quick answer- don't dumpall, just dump the databases that are still
active. You don't
want the inactive databases to migrate anyhow.

-- Matt

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Brian C. Doyle
Sent: Thursday, August 09, 2001 1:36 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] UpGrading to 7.1.2

Hello all,

So I saw to fix a memory error I should upgrade to 7.1.x.
After downloading 7.1.2 I went to back up my database file per
http://www.ca.postgresql.org/users-lounge/docs/7.1/admin/install-upgradi
ng.html

and well I get
pg_dumpall -v > database.bkup
Connection to database 'galaxy' failed.
FATAL 1: Database path could not be resolved.

pg_dump failed on galaxy, exiting

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 I now can not do a
dropdb if I do I get

ERROR: The database path '(null)' is invalid. This may be due to a
character that is not allowed or because the chosen path isn't p
ermitted for databases
dropdb: database removal failed

Which it should do.

Please HELP

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

"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

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: