Re: Postgres - Replication

From: Samed YILDIRIM <samed(at)reddoc(dot)net>
To: jasoninmel <jasoninmel+1(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres - Replication
Date: 2017-03-15 11:21:22
Message-ID: 1398211489576882@web5g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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" &lt;jasoninmel+1(at)gmail(dot)com&gt;:</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>

Attachment Content-Type Size
unknown_filename text/html 1.2 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mario De Frutos 2017-03-15 20:51:35 Convert existing syslog logs to csvlog
Previous Message Albe Laurenz 2017-03-15 09:44:09 Re: Too many WAL file created