Renaming a DB - Mailing list pgsql-admin

From Mendola Gaetano
Subject Renaming a DB
Date
Msg-id 003d01c342d1$5d2304c0$10d4a8c0@mm.eutelsat.org
Whole thread Raw
Responses Re: Renaming a DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all,
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.

however trying after a while ( without do nothing ) I'm
able to connect to "new_name" database, is like the names
of database are cached somewhere and this cache expire
after a while.

Any idea ?


Regards
Gaetano Mendola


pgsql-admin by date:

Previous
From: "Daniel Seichter"
Date:
Subject: Re: No such file or directory: ./configure
Next
From: Tom Lane
Date:
Subject: Re: vacuum warnings with pgsql 7.3.3