| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
| Cc: | Naomi Walker <nwalker(at)eldocomp(dot)com>, Chris Ruprecht <chrup999(at)yahoo(dot)com>, PostGreSQL Admin Group <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Re-nameing a database? |
| Date: | 2002-02-11 17:11:00 |
| Message-ID: | 7656.1013447460@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Oliver Elphick <olly(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simone Tellini | 2002-02-11 17:43:17 | Re: restore whoes |
| Previous Message | Tom Lane | 2002-02-11 17:08:07 | Re: Fwd: Administrative Processing for csitech: getrows |