Re: Re-nameing a database? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Re-nameing a database?
Date
Msg-id 7656.1013447460@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re-nameing a database?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: restore whoes
Next
From: Simone Tellini
Date:
Subject: Re: restore whoes