Re: Delay streaming replication using a paramter

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: Mahmoud Hakeem-Habeeb <Mahmoud(dot)hakeem(dot)habeeb(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Delay streaming replication using a paramter
Date: 2012-10-31 21:17:21
Message-ID: CAJ4CxLkDdm4U=q_QLts2Dv0iVyM0Ca1oTpk2pPP4_AJh8gognQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)hakeem(dot)habeeb(at)gmail(dot)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(at)neadwerx(dot)com | www.neadwerx.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2012-10-31 22:47:57 Re: dropdb breaks replication?
Previous Message Joshua D. Drake 2012-10-31 20:36:23 Re: Unable to do a mailing list proper search