Re: [GENERAL] warm standby resume and take online problems

2009-11-04 Thread Greg Smith
On Wed, 4 Nov 2009, Michal Bicz wrote: Now it is saying constantly in log : 2009-11-04 04:57:39 PST : ERROR:  XX000: xlog flush request 2FB/28CE63A8 is not satisfied --- flushed only to 2FB/8FFEA60 2009-11-04 04:57:39 PST : CONTEXT:  writing block 874937 of relation 1663/20863/21548 2009-11-04

[GENERAL] warm standby resume and take online problems

2009-11-04 Thread Michal Bicz
Hi, I have chain of warm stanby servers. One let's say db-01 is pushing updates to db-02 and then they are fetched to db-03. I decided to bring up online db-04 and stopped db-03 from warm standby with pg_ctl stop -m fast $PG_DATA And copied data over from db-03 to db-04. So now I have backup "d