Re: Convert hot_standby 9.4 postgresql into standalone server

2020-07-14 Thread Tom Lane
"David G. Johnston" writes: > On Tuesday, July 14, 2020, Julie Nishimura wrote: >> 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? > If you are keeping the primary you shouldn’t have to do

Re: Convert hot_standby 9.4 postgresql into standalone server

2020-07-14 Thread David G. Johnston
On Tuesday, July 14, 2020, Julie Nishimura wrote: > 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? > If you are keeping the primary you shouldn’t have to do anything. The absence of a secondary

Convert hot_standby 9.4 postgresql into standalone server

2020-07-14 Thread Julie Nishimura
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,