[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

Re: [GENERAL] xlog flus not satisfied

2009-08-10 Thread Tom Lane
Ow Mun Heng ow.mun.h...@wdc.com 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.

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 ow.mun.h...@wdc.com 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