Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZP7I-0002Sc-TR for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jan 2018 22:45:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZP7H-00062w-V3 for pgsql-admin@arkaria.postgresql.org; Wed, 10 Jan 2018 22:45:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eZP7H-00062h-Kh for pgsql-admin@lists.postgresql.org; Wed, 10 Jan 2018 22:45:03 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eZP7C-0007Bn-MS for pgsql-admin@postgresql.org; Wed, 10 Jan 2018 22:45:02 +0000 Received: from [IPv6:2406:e001:f09:1:70c3:90ad:f089:d084] (unknown [IPv6:2406:e001:f09:1:70c3:90ad:f089:d084]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 9570880363; Thu, 11 Jan 2018 11:44:49 +1300 (NZDT) Subject: Re: Replication mode To: Azimuddin Mohammed Cc: Peter Eisentraut , pgsql-admin@postgresql.org References: From: Mark Kirkwood Message-ID: Date: Thu, 11 Jan 2018 11:44:49 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US Authentication-Results: auth=pass smtp.auth=mark.kirkwood@catalyst.net.nz smtp.mailfrom=mark.kirkwood@catalyst.net.nz List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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