Re: [PERFORM] archive_command too slow.

2016-11-08 Thread Stephen Frost
Greetings, * Joao Junior (jcoj2...@gmail.com) wrote: > I am running 2 Linux machines, kernel 3.13.0-45-generic #74-Ubuntu SMP. > Postgresql version 9.4 in both machine, in a Hot Standby cenario. > > Master-Slave using WAL files, not streaming replication. > > The archive_command from master is:

Re: [PERFORM] archive_command too slow.

2016-11-04 Thread Claudio Freire
On Fri, Nov 4, 2016 at 1:19 PM, Jeff Janes wrote: > If setting up the ssh tunnel is the problem, you could assess whether you > really need that security, or compile a custom postgresql with larger WAL > file sizes, or write a fancy archive_command which first archives the files > to a local direc

Re: [PERFORM] archive_command too slow.

2016-11-04 Thread Jeff Janes
On Wed, Nov 2, 2016 at 12:06 PM, Joao Junior wrote: > Hi friends, > > I am running 2 Linux machines, kernel 3.13.0-45-generic #74-Ubuntu SMP. > Postgresql version 9.4 in both machine, in a Hot Standby cenario. > > Master-Slave using WAL files, not streaming replication. > > The archive_command f

[PERFORM] archive_command too slow.

2016-11-02 Thread Joao Junior
Hi friends, I am running 2 Linux machines, kernel 3.13.0-45-generic #74-Ubuntu SMP. Postgresql version 9.4 in both machine, in a Hot Standby cenario. Master-Slave using WAL files, not streaming replication. The archive_command from master is: archive_command = '/usr/bin/rsync -a -e "ssh" "%p"