Postgres Pro
Downloads
Home   >   mailing lists

Thread: Delay streaming replication using a paramter

Delay streaming replication using a paramter

From
Mahmoud Hakeem-Habeeb
Date:
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

Re: Delay streaming replication using a paramter

From
Magnus Hagander
Date:
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 

Re: Delay streaming replication using a paramter

From
Moshe Jacobson
Date:
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