Re: Re-nameing a database?

Oliver Elphick <olly@lfix.co.uk> writes:
>> is there an easy way to re-name a database?

> In 7.1.3, you can do it by updating the row in pg_database and then
> restarting the postmaster:

I don't believe a postmaster restart is required.  It might be a good
idea to vacuum pg_database and then force a checkpoint, however, just
to make sure the updated row is out on disk and not still hanging about
in a shared-memory buffer.

            regards, tom lane