Re: [GENERAL] xlog flus not satisfied

2009-08-10 Thread Ow Mun Heng
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] "Ow Mun Heng" writes: >> As background, this is a new box mirrored from a separate box via rsync. >> I've basically copied/rsync the entire postgresql server and data files >>over >> to create a mirror copy. After which, I'v

Re: [GENERAL] xlog flus not satisfied

2009-08-10 Thread Tom Lane
"Ow Mun Heng" writes: > As background, this is a new box mirrored from a separate box via rsync. > I've basically copied/rsync the entire postgresql server and data files over > to create a mirror copy. After which, I've tried to do the vacuum and gotten > into the above trouble. Did you shut dow

[GENERAL] xlog flus not satisfied

2009-08-10 Thread Ow Mun Heng
While doing # VACUUM VERBOSE ANALYZE d_trr_dfh; INFO: vacuuming "xmms.d_trr_dfh" ERROR: xlog flush request 21F/9F57DF88 is not satisfied --- flushed only to 21F/924CE76C CONTEXT: writing block 2919652 of relation 17461/17462/17668 I see this in the logs user= CONTEXT: writing block