Re: Convert hot_standby 9.4 postgresql into standalone server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Convert hot_standby 9.4 postgresql into standalone server
Дата
Msg-id 3023063.1594770294@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Convert hot_standby 9.4 postgresql into standalone server  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, July 14, 2020, Julie Nishimura <juliezain@hotmail.com> wrote:
>> Hello, we currently have 9.4 hot_standby master-slave pair. Going forward,
>> we can keep only one server. How can I convert the system properly?

> If you are keeping the primary you shouldn’t have to do anything.  The
> absence of a secondary server shouldn’t impact the primary.  You might be
> recording more detail to WAL than strictly necessary but that isn’t wrong
> outright.

Yeah.  What you *do* need to think about is, if you no longer have
a standby server, what's your disaster recovery plan in case the
primary fails?  You need to have some good backup procedures in place.

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Convert hot_standby 9.4 postgresql into standalone server
Следующее
От: David Rowley
Дата:
Сообщение: Re: some random() clarification needed