Re: [ADMIN] recovery lag question

2009-11-14 Thread John Lister
John Lister wrote: Hi, I've set up a warm standby box with postgresql 8.3.8 and pg_standby. Everything seems to be ok except and the wal files are being copied across and being processed during the recovery as you'd expect but I have one question. The recovery seems to be processing the final wal

Re: [ADMIN] recovery lag question

2009-11-13 Thread Kevin Grittner
Alvaro Herrera wrote: > There is a sleep time between check for new files Even after a successful copy? Why would you want that? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] recovery lag question

2009-11-13 Thread Alvaro Herrera
John Lister wrote: > Hi, I've set up a warm standby box with postgresql 8.3.8 and > pg_standby. Everything seems to be ok except and the wal files are > being copied across and being processed during the recovery as you'd > expect but I have one question. The recovery seems to be processing > the f

[ADMIN] recovery lag question

2009-11-12 Thread John Lister
Hi, I've set up a warm standby box with postgresql 8.3.8 and pg_standby. Everything seems to be ok, the wal files are being copied across and being processed during the recovery as you'd expect but I have one question. The recovery seems to be processing the final wal files at the same rate as t

[ADMIN] recovery lag question

2009-11-12 Thread John Lister
Hi, I've set up a warm standby box with postgresql 8.3.8 and pg_standby. Everything seems to be ok except and the wal files are being copied across and being processed during the recovery as you'd expect but I have one question. The recovery seems to be processing the final wal files (about 30)