Re: db rename

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: db rename
Date: 2004-10-25 14:18:06
Message-ID: 18281.1098713886@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jodi Kanter <jkanter(at)virginia(dot)edu> writes:
> I thought there was an option to rename a database?

No, but you could always do an UPDATE on pg_database. It might be a
good idea to ensure there are no backends running in the target database
when you do the update. (I think that recent releases wouldn't care
particularly, but I'm less sure about 7.3.4.)

regards, tom lane

In response to

  • db rename at 2004-10-25 12:59:03 from Jodi Kanter

Browse pgsql-admin by date

  From Date Subject
Next Message Goulet, Dick 2004-10-25 16:15:32 Psql question
Previous Message Tsirkin Evgeny 2004-10-25 13:42:02 Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg