Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

remote backup seems not to even try to use ssh connection #368

Copy link
Copy link
Open
@yennor

Description

@yennor
Issue body actions

pg_probackup version: pg_probackup-11 2.4.10 (PostgreSQL 11.11)
os version: debian stable on db server and on backup server

I've set a remote backup system up according to the docs.
When on the backupserver i execute:
ssh postgres@dbserver.com
It connects perfectly.
So I've added a backup instance:

pg_probackup-11 add-instance -B /var/lib/pg-probackup-11/ --instance 'test' --remote-host=dbserver.com --remote-port=1024 --remote-user=postgres -D /var/lib/postgresql/11/main
INFO: Instance 'test' successfully inited

So far so good. It connected successfully over ssh. I've checked auth.log on the db server.
But know when I do a backup:

pgbackup@backup:~$ pg_probackup-11 backup -B /var/lib/pg-probackup-11/ -b full --instance 'test' --remote-host=dbserver.com --remote-port=1024 --remote-user=postgres -U backup -d backupdb
INFO: Backup start, pg_probackup version: 2.4.10, instance: test, backup ID: QRQ1QT, backup mode: FULL, wal mode: ARCHIVE, remote: true, compress-algorithm: none, compress-level: 1
ERROR: could not connect to database backupdb: could not connect to server: Connection timed out
Is the server running on host "dbserver.com" (123.123.123.123) and accepting
TCP/IP connections on port 5432?

I've checked out auth.log on the db server. It doesn't even try to connect over ssh. It seems like it tries to open directly an postgresql connection to remote-server?

I've also tried:

pgbackup@backup:~$ pg_probackup-11 backup -B /var/lib/pg-probackup-11/ -b full --instance 'test' --remote-host=dbserver.com --remote-port=1024 --remote-user=postgres --remote-proto=ssh -U backup -d backupdb -h localhost
INFO: Backup start, pg_probackup version: 2.4.10, instance: test, backup ID: QRQ1XU, backup mode: FULL, wal mode: ARCHIVE, remote: true, compress-algorithm: none, compress-level: 1
ERROR: could not connect to database backupdb: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

WARNING: Backup QRQ1XU is running, setting its status to ERROR

And still. It doesn't even try to do a ssh connection (auth.log on the db server is just empty).

I've tried some more stuff, but it seems like I can't get it in any way to use the ssh connection.
--log-level-console=verbose
doesn't help at all. No extra output.
For me it looks like some kind of bug, but since it seems like everybody else got it working.... hmmm ?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.