Postgres Pro
Downloads
Home   >   mailing lists

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

From Magnus Hagander
Subject Re: Delay streaming replication using a paramter
Date
Msg-id CABUevExZM=5f3yRLeNGSZBXntSA3ptqEM8pXEL-_RbTSGqPw1A@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
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 

pgsql-general by date:

Previous
From: Christian Hammers
Date:
Subject: When do archived WAL files gets removed after wal_keep_segments changed?
Next
From: Edson Richter
Date:
Subject: dropdb breaks replication?