From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Azimuddin Mohammed <azimeiu@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replication mode
Date: Thu, 11 Jan 2018 11:44:49 +1300
Message-ID: <a9a09d31-4127-2a19-3bc7-085cf442a310@catalyst.net.nz> (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 11/01/18 11:17, Azimuddin Mohammed 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.
>
Whether you have made the standby/slave hot or merely warm doesn't
really change the 'standby' part - the mechanism is identical (applying
wal information to keep the it up to date with its primary). In either
case they cannot be altered by clients (attempting to) connect to them.
So most folk always make their standbys 'hot' (it is very convenient to
have the *option* of being able to query them if you need to).
Does that help?
Cheers
Mark
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: mark.kirkwood@catalyst.net.nz, azimeiu@gmail.com, peter.eisentraut@2ndquadrant.com
Subject: Re: Replication mode
In-Reply-To: <a9a09d31-4127-2a19-3bc7-085cf442a310@catalyst.net.nz>
* 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