On Wed, May 21, 2008 at 4:14 AM, Vlad Kosilov <[EMAIL PROTECTED]> wrote:
> as Greg pointed out: my use of rsync --remove-sent-files option had
> contributed to a short sized wal log file on standby.
> changing master's postgres crontab to the following helped to resolve the
> issue:
>
> # ship logs to standby:
> */2 * * * * rsync -aq /wal_archive_local/ 10.10.10.12::wal_archive/
> # remove files older then remove_check file mtime
> */5 * * * * find /wal_archive_local/ ! -newer
> /wal_archive_local/remove_check -exec rm -f {} \; && touch
> /wal_archive_local/remove_check
>
>
Hmmm, nice trick.
--
[EMAIL PROTECTED]
[EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
