Can you not change your method of streaming replication. What is your archive command, are you using rsync as you can control the bandwidth limit?
We use: archive_command = 'test ! -f /opt/postgres/remote_pgsql/wal_archive/%f && rsync -az %p /opt/postgres/remote_pgsql/wal_archive/%f' According to the link below you can add --bwlimit=1000 to the rsync arguments http://scratching.psybermonkey.net/2009/03/rsync-transfer-rate-limit-aka-it-down.html On 25 January 2013 12:59, Magnus Hagander <mag...@hagander.net> wrote: > On Fri, Jan 25, 2013 at 1:59 PM, Rodrigo Pereira da Silva > <rodr...@paripassu.com.br> wrote: > > Hi Guys, > > > > We are having a problem with our infrastructure provider because the > network > > traffic between master and slave server is reaching more than 30k > packages > > per second(SLA says 20k/second). > > Is there any way to throttle the streamming replication? I meant, any > > parameter that I set the max number of megabytes sent to standby server > per > > second? > > I didn't have any luck looking at the postgresql streamming replication > > documentation. There is the wal_sender_delay, but I suppose that if I set > > more than 1 second, it could accumulate a bunch of wal files and send it > at > > once. So, it wouldn't work. > > No, there is no such parameter. You might be able to send it through > some proxy that slows it down, but there is no builtin support to do > that. > > -- > Magnus Hagander > Me: http://www.hagander.net/ > Work: http://www.redpill-linpro.com/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
