Convert hot_standby 9.4 postgresql into standalone server

Поиск
Список
Период
Сортировка
От Julie Nishimura
Тема Convert hot_standby 9.4 postgresql into standalone server
Дата
Msg-id BYAPR08MB5014BADC15CDCAFC0B5A4059AC610@BYAPR08MB5014.namprd08.prod.outlook.com
обсуждение исходный текст
Ответы Re: Convert hot_standby 9.4 postgresql into standalone server  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
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?

These are some snippets from master postgresql.conf file:

==================================
wal_level = hot_standby                 # minimal, archive, hot_standby, or logical
                                        # (change requires restart)
                                        checkpoint_segments = 16
wal_keep_segments = 512
max_wal_senders = 16            # max number of walsender processes
                                # (change requires restart)
max_replication_slots = 12      # max number of replication slots
===================================

Is it enough if I do the following:
1) backup all dbs on master
2) shutdown both servers
3) update max_replication_slots=0 in postgresql.conf on master
4) update wal_level = minimal in postgresql.conf on master
4) start master

Do I need to do anything else? Thank you for your help

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

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: Problem with FDW wrapper errors
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Convert hot_standby 9.4 postgresql into standalone server