From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | jik(at)foxinternet(dot)net |
Cc: | psql <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: renaming a db |
Date: | 2001-09-03 21:35:41 |
Message-ID: | 6597.999552941@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
jik(at)foxinternet(dot)net writes:
> Tom Lane wrote:
>>> I have a feeling I can't do it, but is there a way to rename a dB?
>>
>> In 7.1 or later I think it would work to just UPDATE the db's row in
>> pg_database. But don't blame me if this fails to work ... make a
>> backup before you try it.
> Doesn't look like that works....you ruined my database, I bet they fire
> me :P
> jik-=# UPDATE pg_database SET datname='test34' WHERE datname='test2';
> UPDATE 1
> jik-=# \c test34
> FATAL 1: Database "test34" does not exist in the system catalog.
> Previous connection kept
I find that it starts working after you do a CHECKPOINT ... or wait for
one to happen automatically. (A would-be backend won't see the
pg_database change until the table update is flushed to disk.)
foo=# update pg_database set datname = 'bar' where datname='foo';
UPDATE 1
foo=# checkpoint;
CHECKPOINT
-- now I can connect to 'bar'
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | John E. Michelsen | 2001-09-04 01:37:49 | Is postgreSql really suitable? |
Previous Message | jik | 2001-09-03 20:27:51 | Re: renaming a db |