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
|
| Список | 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 по дате отправления: