Re: Renaming a DB - Mailing list pgsql-admin

From Tom Lane
Subject Re: Renaming a DB
Date
Msg-id 6927.1057455407@sss.pgh.pa.us
Whole thread Raw
In response to Renaming a DB  ("Mendola Gaetano" <mendola@bigfoot.com>)
Responses Re: Renaming a DB  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
"Mendola Gaetano" <mendola@bigfoot.com> writes:
> I'm running a Postgres 7.3.3 and I had the necessity to
> rename a DB, I did this by updating the pg_database
> table.
> If I perform psql -l  I'm able to see that is reported the
> correct name ( I guess because a select on pg_database
> table is performed ) but if I try to connect to the DB
> after the renaming I obtain the error:
> psql: FATAL:  Database "new_name" does not exist in
> the system catalog.

Try vacuuming pg_database (you can do this from any database,
it need not be the one that is having the problem).

            regards, tom lane

pgsql-admin by date:

Previous
From: "Arumugam"
Date:
Subject: Pls. help me to clarify my doubts.
Next
From: "Mendola Gaetano"
Date:
Subject: Re: Renaming a DB