Hello,
I'd like to set up an connection in pgAdmin4 to the primary host of a
replicated Postgres cluster behind an SSH gateway.
To always connect to the primary DB host (without knowing beforehand
which one will be primary at the time of connection), I figured I have
to create a service file to feed target_session_attrs to libpq.
I created such a file, including a service for the ssh tunneled
connection (to keep it simple for testing, only IP and port of current
primary, no target_session_attrs)
and a second service to a DB server reachable without tunneling, also
only IP and port.
I already have working tunneled connections to each single DB host
behind the ssh gateway.
My results are:
* SSH tunneled connections working fine.
In "Register Server/Connection" the fields "Host name" and "Port" are
set.
* Connection via service to the DB host reachable without ssh working
fine.
In "Register Server/Connection" the fields "Host name" and "Port" are
empty, values from service are used as expected.
* Connection via service and ssh tunnel can not be set up. If I try to
combine the above (fields "Host name" and "Port" empty, field "Service"
set AND enabled SSH tunnel) I get an error "IP is not a string
(NoneType)" and I can't proceed.
Now after thinking a bit about it -- is it even possible to use libpq-
services behind ssh tunneling? If it is possible, how to set up in
pgAdmin4?
I'd be glad for any hints where to look for further information.
Best regards,
Jürgen