From: | bricklen <bricklen(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Archiver not picking up changes to archive_command |
Date: | 2010-05-11 00:01:03 |
Message-ID: | AANLkTinmg9-gtu9NUxebe-NKfk5dkhNY2-sa1H0-WxCr@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
I'm stumped by an issue we are experiencing at the moment. We have
been successfully archiving logs to two standby sites for many months
now using the following command:
rsync -a %p postgres(at)192(dot)168(dot)80(dot)174:/WAL_Archive/ && rsync
--bwlimit=1250 -az %p postgres(at)14(dot)121(dot)70(dot)98:/WAL_Archive/
Due to some heavy processing today, we have been falling behind on
shipping log files (by about a 1000 logs or so), so wanted to up our
bwlimit like so:
rsync -a %p postgres(at)192(dot)168(dot)80(dot)174:/WAL_Archive/ && rsync
--bwlimit=1875 -az %p postgres(at)14(dot)121(dot)70(dot)98:/WAL_Archive/
The db is showing the change.
SHOW archive_command:
rsync -a %p postgres(at)192(dot)168(dot)80(dot)174:/WAL_Archive/ && rsync
--bwlimit=1875 -az %p postgres(at)14(dot)121(dot)70(dot)98:/WAL_Archive/
Yet, the running processes never get above the original bwlimit of
1250. Have I missed a step? Would "kill -HUP <archiver pid>" help?
(I'm leery of trying that untested though)
ps aux | grep rsync
postgres 27704 0.0 0.0 63820 1068 ? S 16:55 0:00 sh -c
rsync -a pg_xlog/000000010000071700000070
postgres(at)192(dot)168(dot)80(dot)174:/WAL_Archive/ && rsync --bwlimit=1250 -az
pg_xlog/000000010000071700000070 postgres(at)14(dot)121(dot)70(dot)98:/WAL_Archive/
postgres 27714 37.2 0.0 68716 1612 ? S 16:55 0:01 rsync
--bwlimit=1250 -az pg_xlog/000000010000071700000070
postgres(at)14(dot)121(dot)70(dot)98:/WAL_Archive/
postgres 27715 3.0 0.0 60764 5648 ? S 16:55 0:00 ssh
-l postgres 14.121.70.98 rsync --server -logDtprz --bwlimit=1250 .
/WAL_Archive/
Thanks,
bricklen
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-05-11 00:04:45 | Re: initdb fails on Centos 5.4 x64 |
Previous Message | Tom Lane | 2010-05-10 23:47:00 | Re: Crazy looking actual row count from explain analyze |
From | Date | Subject | |
---|---|---|---|
Next Message | bricklen | 2010-05-11 00:04:53 | Re: Archiver not picking up changes to archive_command |
Previous Message | Greg Smith | 2010-05-10 23:03:34 | Re: no universally correct setting for fsync |