| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Convert hot_standby 9.4 postgresql into standalone server |
| Date: | 2020-07-14 23:44:54 |
| Message-ID: | 3023063.1594770294@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tuesday, July 14, 2020, Julie Nishimura <juliezain(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2020-07-14 23:53:21 | Re: some random() clarification needed |
| Previous Message | David G. Johnston | 2020-07-14 23:41:37 | Re: Convert hot_standby 9.4 postgresql into standalone server |