Re: Renaming a DB

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Mendola Gaetano" <mendola(at)bigfoot(dot)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).

A normal vacuum was not enough I did a vacuum full and seems
working.

Thank you
Gaetano Mendola