Re: Replacing a production db - Mailing list pgsql-general

From Tim Clarke
Subject Re: Replacing a production db
Date
Msg-id 53A1FC77.9050507@manifest.co.uk
Whole thread Raw
In response to Re: Replacing a production db  (Nicolás Lichtmaier <nico.lichtmaier@gmail.com>)
List pgsql-general
On 18/06/14 21:50, Nicolás Lichtmaier wrote:
> I'm probably doing this wrong, but I couldn't find any resources to
> learn how to get this right.
>
> Can the renaming be done without disruption to current connections?
> From what I've read you have to disconnect everyone before renaming a
> database.

I'd change the pointer instead; in your client or front-end application
at your release point, change the reference to which database to work
with to the new one.

--
Tim Clarke



pgsql-general by date:

Previous
From: Nicolás Lichtmaier
Date:
Subject: Re: Replacing a production db
Next
From: John R Pierce
Date:
Subject: Re: Replacing a production db