Postgres Pro
Downloads
Home   >   mailing lists

Re: Delay streaming replication using a paramter - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: Delay streaming replication using a paramter
Date
Msg-id CAJ4CxLkDdm4U=q_QLts2Dv0iVyM0Ca1oTpk2pPP4_AJh8gognQ@mail.gmail.com
Whole thread Raw
In response to Delay streaming replication using a paramter  (Mahmoud Hakeem-Habeeb <Mahmoud.hakeem.habeeb@gmail.com>)
List pgsql-general
Tree view
You would like to delay the replication of data from the master to the slave in order to prevent the possibility of corrupted data being sent to the slave?
I don't understand this strategy. Can you explain?

On Wed, Oct 31, 2012 at 8:01 AM, Mahmoud Hakeem-Habeeb <Mahmoud.hakeem.habeeb@gmail.com> wrote:
Hi,
Firstly is it possible for me to delay streaming replication using 

wal_sender_delay

or any other parameter.

Secondly is it possible or under what circumstance will a slave get corrupted from the master either a table of a database.

This is the reason i want to find out if it is possible to delay replication incase of any corruption of data not propagating to the slave.

Thanks


--
MAHH
Network/System Analyst
07788174559



--
Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Unable to do a mailing list proper search
Next
From: Greg Williamson
Date:
Subject: Re: dropdb breaks replication?