On Sun, Dec 30, 2018 at 5:52 PM Chuck Martin <clmartin@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.
