On Sun, Dec 30, 2018 at 5:52 PM Chuck Martin <clmar...@theombudsman.com> 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 the terminal session you were using to run it. If this is your problem you could ( should, IMO ) install something like tmux / screen which is really a life saver for this cases. ( I'll recommend tmux if you've never used one of them, they are terminal multiplexers which allow you to open a session, runs some terminal sessions under it and connect/disconnect/reconnect to them, and specially when your ssh barfs they just disconnect the session, so you just ssh again and reconnect. They are great when you have long running termina commands like pg_basebackup / pg_dump, I routinely use them to launch a long running process and just reconnect periodically to check on it ). Francisco Olarte.
