Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZQdH-0000ST-JE for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2018 00:22:11 +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 1eZQdG-0001o3-JH for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2018 00:22:10 +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 1eZQdG-0001nt-8r for pgsql-admin@lists.postgresql.org; Thu, 11 Jan 2018 00:22:10 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eZQdB-0001Xp-SW for pgsql-admin@postgresql.org; Thu, 11 Jan 2018 00:22:08 +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 2BCBD80A06; Thu, 11 Jan 2018 13:21:55 +1300 (NZDT) Subject: Re: Replication mode To: Azimuddin Mohammed Cc: Peter Eisentraut , pgsql-admin@postgresql.org References: From: Mark Kirkwood Message-ID: <97973de0-8de3-a7eb-d702-da7d680e8ccb@catalyst.net.nz> Date: Thu, 11 Jan 2018 13:21:55 +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: 8bit 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 13:08, Azimuddin Mohammed wrote: > Thanks mark.. > That does help... > Our db is not transactional ..it more of write few times read many > times ..What HA  do you  recommend for us by not using any open source > tools...and what could be the best backup startegy... > Wow - that 'not using any open source tools' restriction pretty much rules out any options I'd come up with (was that *really* what you meant to write - Postgres is after all open source too...)? regards Mark