Re: getting pg_basebackup to use remote destination

2019-01-03 Thread Chuck Martin
On Thu, Jan 3, 2019 at 3:46 PM Stephen Frost wrote: > Greetings Chuck, > > * Chuck Martin (clmar...@theombudsman.com) wrote: > > Using iperf, the transfer speed between the two servers (from the main to > > the standby) was 938 Mbits/sec. If I understand the units correctly, it > is > > close to

Re: getting pg_basebackup to use remote destination

2019-01-03 Thread Stephen Frost
Greetings Chuck, * Chuck Martin (clmar...@theombudsman.com) wrote: > Using iperf, the transfer speed between the two servers (from the main to > the standby) was 938 Mbits/sec. If I understand the units correctly, it is > close to what it can be. That does look like the rate it should be going at

Re: getting pg_basebackup to use remote destination

2018-12-31 Thread Chuck Martin
On Mon, Dec 31, 2018 at 12:05 PM Jeff Janes wrote: > On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin > wrote: > >> Maybe I need to rethink ths and take Jeff's advice. I executed this: >> >> pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D >> /mnt/dbraid/data >> >> 8 hours ago, and it

Re: getting pg_basebackup to use remote destination

2018-12-31 Thread Jeff Janes
On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin wrote: > Maybe I need to rethink ths and take Jeff's advice. I executed this: > > pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D > /mnt/dbraid/data > > 8 hours ago, and it is now still at 1%. Should it be that slow? The > database in qu

Re: getting pg_basebackup to use remote destination

2018-12-30 Thread Chuck Martin
Maybe I need to rethink ths and take Jeff's advice. I executed this: pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D /mnt/dbraid/data 8 hours ago, and it is now still at 1%. Should it be that slow? The database in question is about 750 GB, and both servers are on the same GB ethern

Re: getting pg_basebackup to use remote destination

2018-12-30 Thread Jeff Janes
On Sat, Dec 29, 2018 at 2:05 PM Chuck Martin wrote: > I thought I knew how to do this, but I apparently don't. I have to set up > a new server as a standby for a PG 11.1 server. The main server has a lot > more resources than the standby. What I want to do is run pg_basebackup on > the main serve

Re: getting pg_basebackup to use remote destination

2018-12-30 Thread Francisco Olarte
On Sun, Dec 30, 2018 at 5:52 PM Chuck Martin wrote: .. > I’ve started pg_basebackup from the standby. It failed once due to an ssh > error, but I reloaded sshd and started again. May take a while. It about > 750gb. IIRC pg_base backup uses the postgres connection, so I supose ssh failed on

Re: getting pg_basebackup to use remote destination

2018-12-30 Thread Chuck Martin
On Sun, Dec 30, 2018 at 11:20 AM Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > On 29/12/2018 20:04, Chuck Martin wrote: > > I thought I knew how to do this, but I apparently don't. I have to set > > up a new server as a standby for a PG 11.1 server. The main server has a > > lot mo

Re: getting pg_basebackup to use remote destination

2018-12-30 Thread Peter Eisentraut
On 29/12/2018 20:04, Chuck Martin wrote: > I thought I knew how to do this, but I apparently don't. I have to set > up a new server as a standby for a PG 11.1 server. The main server has a > lot more resources than the standby. What I want to do is run > pg_basebackup on the main server with the ou

Re: getting pg_basebackup to use remote destination

2018-12-29 Thread Adrian Klaver
On 12/29/18 11:04 AM, Chuck Martin wrote: I thought I knew how to do this, but I apparently don't. I have to set up a new server as a standby for a PG 11.1 server. The main server has a lot more resources than the standby. What I want to do is run pg_basebackup on the main server with the outpu

getting pg_basebackup to use remote destination

2018-12-29 Thread Chuck Martin
I thought I knew how to do this, but I apparently don't. I have to set up a new server as a standby for a PG 11.1 server. The main server has a lot more resources than the standby. What I want to do is run pg_basebackup on the main server with the output going to the data directory on the new serve