Re: Delay streaming replication using a paramter

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Mahmoud Hakeem-Habeeb <Mahmoud(dot)hakeem(dot)habeeb(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delay streaming replication using a paramter
Date: 2012-10-31 16:54:28
Message-ID: CABUevExZM=5f3yRLeNGSZBXntSA3ptqEM8pXEL-_RbTSGqPw1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2012-10-31 17:32:19 dropdb breaks replication?
Previous Message Christian Hammers 2012-10-31 16:21:31 When do archived WAL files gets removed after wal_keep_segments changed?