Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

<p>so I from by like having the server doing the cleanup because it down by necessarily have the while picture. it down
ntknow of it is the only replica reading these log files our if the site policy is to keep them for disaster recovery
purposes.<p>Ilike having this as an return val command though. Or alternately now that we have read-only replicas you
couldimplement this by polling the slaves and asking them what log position they are up to.<br /><br
/><p>greg<p><blockquotetype="cite">On 12 Feb 2010 17:25, "Dimitri Fontaine" <<a
href="mailto:dfontaine@hi-media.com">dfontaine@hi-media.com</a>>wrote:<br /><br /><p><font color="#500050">Simon
Riggs<simon@2ndQuadrant.com> writes:</font><p><font color="#500050">> Attached patch implements pg_standby for
useas an<br />> archive_cleanup_command, reusing existing cod...</font><p><font color="#500050">> Happy to add
thearchive_cleanup_command into main server as well, if<br /> > you like. Won't take long....</font>Would it be
possibleto have the server do the cleanup (and the cp for<br /> that matter) on its own or use a script?<br /><br />
Eitherhave archive_cleanup = on and either an commented out (empty)<br /> archive_cleanup_command and the same for the
restore_command,or a<br /> special magic value, like 'postgresql' to activate the internal one.<br /><br /> This way we
haveboth a zero config working default setup and the<br /> flexibility to adapt to any archiving solution our user
mightalready be<br /> using.<br /><br /> A default archive_command would be nice too. Like you give it a<br />
directoryname or a rsync path and it does the basic right thing.<br /><br /> I'm not sure my detailed approach is the
rightone, but the birdview is<br /> to have the simple case really simple to setup, and the complex cases<br /> still
possible.Default included archive, restore and cleanup commands<br /> would be awesome.<br /><br /> Oh, and the basic
simplecase actually is with a remote standby. Without<br /> NFS or the like, no shared mount point for archiving.<br
/><br/> Regards,<br /><font color="#888888">--<br /> dim<br /></font><p><font color="#500050"><br />-- <br />Sent via
pgsql-hackersmailing list (<a href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br />To make
changesto your subs...</font></blockquote>