way to limit speed of repmgr clone process
Closed this issue · 3 comments
hi, everyone
today, I was testing scale out postgresql instance on my environment using repmgr clone.
in the middle of clone process, I have noticed that there's significant amount of disk usage on the target postgresql instance.
seems like it will hurt my running postgresql server's query performance.
I looked up manual for list of options that I can use with repmgr clone command and seems like there's no option related
to limit the speed of cloning process.
And I thought it would be useful to have that kind of feature.
So will there be any way to solve my problem? or any plans to implement feature like that?
I'll make some time to test on my own and post any update here as well.
repmgr uses pg_basebackup to perform the actual cloning. You can use the repmgr.conf parameter pg_basebackup_options to pass arbitrary parameters to pg_basebackup, in this case you'd want the -r/--max-rate option (see pg_basebackup documentation), e.g.:
...
pg_basebackup_options = '--max-rate=1024'
...
repmgrusespg_basebackupto perform the actual cloning. You can use therepmgr.confparameterpg_basebackup_optionsto pass arbitrary parameters topg_basebackup, in this case you'd want the-r/--max-rateoption (see pg_basebackup documentation), e.g.:... pg_basebackup_options = '--max-rate=1024' ...
That's what i have looking for.
Thanks very much. I'll test that and close the issue afterwards.
Sean
I have tested "pg_basebackup_options" and it worked like a charm!!
Again, Thank you for your quick & kind advice.