From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Convert hot_standby 9.4 postgresql into standalone server |
Date: | 2020-07-14 23:25:54 |
Message-ID: | BYAPR08MB5014BADC15CDCAFC0B5A4059AC610@BYAPR08MB5014.namprd08.prod.outlook.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-07-14 23:41:37 | Re: Convert hot_standby 9.4 postgresql into standalone server |
Previous Message | Michael Nolan | 2020-07-14 23:24:57 | Re: Problem with FDW wrapper errors |