Re: [ADMIN] Postgres - Replication - Mailing list pgsql-admin

From Samed YILDIRIM
Subject Re: [ADMIN] Postgres - Replication
Date
Msg-id 1398211489576882@web5g.yandex.ru
Whole thread Raw
In response to [ADMIN] Postgres - Replication  (jasoninmel <jasoninmel+1@gmail.com>)
Responses Re: [ADMIN] Postgres - Replication  (jasoninmel <jasoninmel+1@gmail.com>)
List pgsql-admin
Hi Jason,
 
How much data loss toleration do you have? Which version of Postgres are you using?
 
If no data loss is required and Postgres version is 9.6, you can use synchronous replication.
If you have data loss tolerance you can use asynchronous replication or delayed replication.
 
Best regards.
 
İyi çalışmalar.
Samed YILDIRIM
 
 
 
15.03.2017, 08:01, "jasoninmel" <jasoninmel+1@gmail.com>:
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
View this message in context: Postgres - Replication
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [ADMIN] Too many WAL file created
Next
From: Mario De Frutos
Date:
Subject: [ADMIN] Convert existing syslog logs to csvlog