Re: Replication mode - Mailing list pgsql-admin

From scott ribe
Subject Re: Replication mode
Date
Msg-id 3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com
Whole thread Raw
In response to Re: Replication mode  (Azimuddin Mohammed <azimeiu@gmail.com>)
List pgsql-admin
On Jan 10, 2018, at 3:17 PM, Azimuddin Mohammed <azimeiu@gmail.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
readoperation and let my primary server do all read and write operation. If my primary fails I will do manual failover.
Thewhole idea is to remove any 3rd party open source tools as we are not sure how well they behave and avoid any single
pointof 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



pgsql-admin by date:

Previous
From: Satish
Date:
Subject: Re: Replication mode
Next
From: Mark Kirkwood
Date:
Subject: Re: Replication mode