Re: Replacing a production db

Поиск
Список
Период
Сортировка
От Tim Clarke
Тема Re: Replacing a production db
Дата
Msg-id 53A1FC77.9050507@manifest.co.uk
обсуждение исходный текст
Ответ на Re: Replacing a production db  (Nicolás Lichtmaier <nico.lichtmaier@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Nicolás Lichtmaier
Дата:
Сообщение: Re: Replacing a production db
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Replacing a production db