Connecting to replicated Postgres behind SSH gateway

[Freitag Jürgen]

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




smime.p7s
Description: S/MIME cryptographic signature

Opening multiple instances of PgAdmin4 v6

[Rohan Nautiyal (TMNA)]

** PROTECTED 関係者外秘

Hi PgAdmin support,

When we run a stored procedure in PgAdmin4 v6 client, we can’t do anything else 
in that DB.
Meaning nothing else opens up and keeps showing In-progress.

We tried to open multiple instances of the client but it does not open that too.
So, request you to kindly suggest a work-around for this.

Thanks & Regards,
Rohan Nautiyal
On assignment @ Toyota Motor North America

Re: Opening multiple instances of PgAdmin4 v6

[Akshay Joshi]

Hi Rohan

Can you please provide the screenshots and logs? If possible please provide
the exact reproduction steps.

On Tue, Sep 6, 2022 at 11:53 PM Rohan Nautiyal (TMNA) <
rohan.nauti...@toyota.com> wrote:

> •• PROTECTED 関係者外秘
>
> Hi PgAdmin support,
>
>
>
> When we run a stored procedure in PgAdmin4 v6 client, we can’t do anything
> else in that DB.
>
> Meaning nothing else opens up and keeps showing In-progress.
>
>
>
> We tried to open multiple instances of the client but it does not open
> that too.
>
> So, request you to kindly suggest a work-around for this.
>
>
>
> Thanks & Regards,
>
> Rohan Nautiyal
>
> On assignment @ Toyota Motor North America
>
>
>


-- 



Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com