Horton

Re: Rename a database that has connections

Mark Kirkwood <mark.kirkwood@catalyst.net.nz>

View thread
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-11-22T04:29:46Z
Lists: pgsql-hackers 
On 22/11/11 17:24, Mark Kirkwood wrote:
>
> I have not been able to find any other problems caused by this... 
> renaming a db (many times) with hundreds of pgbench connections does 
> not give rise to any issues.
>
>

One point I did miss - the ps listing still uses the old dbname. 
pg_stat_activity is correct however.

regards

Mark