| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Duco Fijma <duco(at)fijma(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: %r in restore_command? |
| Date: | 2009-04-02 13:28:13 |
| Message-ID: | 20090402132813.GA3163@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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-standby-configuration in
> combination with pg_standby and _sometimes_ my archive on shipped
> transaction logs grow really huge. The value of %r then never changes
> any more in subsequent calls of the restore_command, causing pg_standby
> to not delete any WAL segment anymore.
AFAIR %r is supposed to mean "the earliest segment that can safely be
removed"(*). If there's a lot of backlog then perhaps the recovery
process has stopped replaying WAL segments for some reason. Is there
anything unusual in the slave logs?
(*) I *think* the technical definition is "segment previous to the one
on which the last restartpoint was set", or something similar.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | linnewbie | 2009-04-02 13:33:44 | Re: Posgres Adding braces at beginning and end of text (html) content |
| Previous Message | Leif B. Kristensen | 2009-04-02 12:59:53 | Re: Posgres Adding braces at beginning and end of text (html) content |