Convert hot_standby 9.4 postgresql into standalone server - Mailing list pgsql-general

From Julie Nishimura
Subject Convert hot_standby 9.4 postgresql into standalone server
Date
Msg-id BYAPR08MB5014BADC15CDCAFC0B5A4059AC610@BYAPR08MB5014.namprd08.prod.outlook.com
Whole thread Raw
Responses Re: Convert hot_standby 9.4 postgresql into standalone server
List 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 by date:

Previous
From: Michael Nolan
Date:
Subject: Re: Problem with FDW wrapper errors
Next
From: "David G. Johnston"
Date:
Subject: Re: Convert hot_standby 9.4 postgresql into standalone server