| From: | scott ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Azimuddin Mohammed <azimeiu(at)gmail(dot)com> |
| Cc: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Replication mode |
| Date: | 2018-01-10 22:43:26 |
| Message-ID: | 3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Jan 10, 2018, at 3:17 PM, Azimuddin Mohammed <azimeiu(at)gmail(dot)com> wrote:
>
> Thanks!
> But with hot standby my slave will be in read-only mode ...how can I just use my slave as a backup and not do any read operation and let my primary server do all read and write operation. If my primary fails I will do manual failover. The whole idea is to remove any 3rd party open source tools as we are not sure how well they behave and avoid any single point of failure.
Just don't send queries to the slave. (There is nothing in PG that would automatically distribute queries to it.)
--
Scott Ribe
https://www.linkedin.com/in/scottribe/
(303) 722-0567
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2018-01-10 22:44:49 | Re: Replication mode |
| Previous Message | Satish | 2018-01-10 22:40:19 | Re: Replication mode |