Re: [GENERAL] %r in restore_command?

2009-04-03 Thread Duco Fijma
Alvaro Herrera wrote: Duco Fijma wrote: Please allow me to rephrase a question I asked on this list some time ago. Could somebody shine some light on what exactly influences the value of the %r parameter in the restore_command (as used in recovery.conf)? I'm using this in a hot-st

[GENERAL] %r in restore_command?

2009-04-01 Thread Duco Fijma
Hi, Please allow me to rephrase a question I asked on this list some time ago. Could somebody shine some light on what exactly influences the value of the %r parameter in the restore_command (as used in recovery.conf)? I'm using this in a hot-standby-configuration in combination with pg_stand

[GENERAL] lots of WAL files retained with restore_command through %r parameter

2009-03-24 Thread Duco Fijma
to restore_command is calculated. Could the problem be some long lasting transaction on the master? Any other condition I could check? The documentation states that %r points to the WAL with the last valid restart point. However, I could not find a further definition of the term "restart po