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

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, July 14, 2020, Julie Nishimura <juliezain@hotmail.com> 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