[GENERAL] Postgres 9.0.4 replication issue: FATAL: requested WAL segment 0000000100000B110000000D has already been removed

2011-11-19 Thread Ashish Gupta
Hi, Database streaming is not taking place. The WAL segment that slave is looking for does not exist on Master. Both Master and Slave are EC2 instances with Postgres version 9.0.04 and Ubuntu 10.04. As per my understanding, DB replication was stalled for around 3 months. On Master new 16 MB WAL i

Re: [GENERAL] Postgres 9.0.4 replication issue: FATAL: requested WAL segment 0000000100000B110000000D has already been removed

2011-11-21 Thread Ashish Gupta
Hi Tomas, Thanks. Increasing the wal_keep_segments to 4000 did the trick. I will set up WAL archive as well. Thanks again. Ashish. On Sat, Nov 19, 2011 at 5:59 PM, Tomas Vondra wrote: > Hi, > > On 19 Listopad 2011, 10:44, Ashish Gupta wrote: > > I searched on various forum