"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