Search Postgresql Archives

Convert hot_standby 9.4 postgresql into standalone server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux