Convert hot_standby 9.4 postgresql into standalone server

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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