Re: Replacing a production db

From: Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Replacing a production db
Date: 2014-06-18 20:54:15
Message-ID: 53A1FC77.9050507@manifest.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-06-18 20:59:36 Re: Replacing a production db
Previous Message Nicolás Lichtmaier 2014-06-18 20:50:26 Re: Replacing a production db