From: Samed YILDIRIM <samed@reddoc.net>
To: jasoninmel <jasoninmel+1@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres - Replication
Date: Wed, 15 Mar 2017 14:21:22 +0300
Message-ID: <1398211489576882@web5g.yandex.ru> (raw)
In-Reply-To: <1489553982608-5949678.post@n3.nabble.com>
References: <1489553982608-5949678.post@n3.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<div>Hi Jason,</div><div> </div><div>How much data loss toleration do you have? Which version of Postgres are you using?</div><div> </div><div>If no data loss is required and Postgres version is 9.6, you can use synchronous replication.</div><div>If you have data loss tolerance you can use asynchronous replication or delayed replication.</div><div> </div><div>Best regards.</div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>15.03.2017, 08:01, "jasoninmel" <jasoninmel+1@gmail.com>:</div><blockquote type="cite">Hi there, I have used Postgres with Master/Slave setup and I've used streaming replication to keep the slave instance up to date with Master. Now I want to have a DR site and ensure the secondary site also has up to date data. What is the best replication method recommended for this purpose? Thanks, Jason<hr width="300" align="left" /> View this message in context: <a href="http://www.postgresql-archive.org/Postgres-Replication-tp5949678.html">Postgres - Replication</a><br />Sent from the <a href="http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html">PostgreSQL - admin mailing list archive</a> at Nabble.com.</blockquote>
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: samed@reddoc.net, jasoninmel+1@gmail.com
Subject: Re: Postgres - Replication
In-Reply-To: <1398211489576882@web5g.yandex.ru>
* 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