| From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | "Vlad Kosilov" <vkosilov(at)contigo(dot)com> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Ioannis Tambouras" <ioannis(at)akroninc(dot)net>, vkosilov(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_standby stuck on a wal file size <16MB |
| Date: | 2008-05-21 02:56:27 |
| Message-ID: | 65937bea0805201956r9884e9vbb59470c5bef6a2a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 21, 2008 at 4:14 AM, Vlad Kosilov <vkosilov(at)contigo(dot)com> 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.
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Dale | 2008-05-21 06:06:57 | Re: Server Configuration |
| Previous Message | Simon Riggs | 2008-05-21 01:51:43 | Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot" |