Archiver not picking up changes to archive_command

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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