From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mendola Gaetano <mendola(at)bigfoot(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Renaming a DB |
Date: | 2003-07-21 03:58:40 |
Message-ID: | 200307210358.h6L3wem24028@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tom Lane 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).
Tom, why was a VACUUM FULL required?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-21 04:09:27 | Re: Renaming a DB |
Previous Message | Nick Fankhauser | 2003-07-20 22:11:07 | PG_dump fatal error (second post) |