pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: scott ribe <scott_ribe@elevated-dev.com>
To: Azimuddin Mohammed <azimeiu@gmail.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replication mode
Date: Wed, 10 Jan 2018 15:43:26 -0700
Message-ID: <3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com> (raw)
In-Reply-To: <CAKUuFd72Daabtt4Hyyd7Nr_vUEVkN82Q8wJpdCkCBwC63ZS4yQ@mail.gmail.com>
References: <CAKUuFd5rq4k0HnPYOf0AuUrSRaL-iNwPYFe=e84qmtwrBMG+Gg@mail.gmail.com>
	<ec6b33ee-e6da-bde5-5c42-c15b847a5b30@2ndquadrant.com>
	<eb965246-4bba-a47e-b939-a6279c632c7b@catalyst.net.nz>
	<CAKUuFd72Daabtt4Hyyd7Nr_vUEVkN82Q8wJpdCkCBwC63ZS4yQ@mail.gmail.com>

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 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

view thread (16+ messages)  latest in thread

Message-ID: <3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com>
Permalink:  ../3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com/
Also on:    postgresql.org/message-id/3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, azimeiu@gmail.com, mark.kirkwood@catalyst.net.nz, peter.eisentraut@2ndquadrant.com
  Subject: Re: Replication mode
  In-Reply-To: <3739944C-1F15-4284-AC32-2B7A9D5E45CF@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox