"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Tuesday, July 14, 2020, Julie Nishimura <juliezain@xxxxxxxxxxx> 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 server shouldn’t impact the primary. You might be > recording more detail to WAL than strictly necessary but that isn’t wrong > outright. Yeah. What you *do* need to think about is, if you no longer have a standby server, what's your disaster recovery plan in case the primary fails? You need to have some good backup procedures in place. regards, tom lane
