Delay streaming replication using a paramter

On Wed, Oct 31, 2012 at 1:01 PM, 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.

No, you can't do delayed replication on streaming. You can do it if you use
file based replication only.

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.

I don't understand this question, so I can't answer it. Sorry.

//Magnus

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