Re: ssh tunneling

Thanks, I'll look into it.

El mar, 23 ene 2024 a la(s) 6:49 p.m., Jon Raiford (raiford(at)labware(dot)com)
escribió:

> As Dave mentions, SSH tunneling should work ok. You need to make sure you
> set up the tunnel correctly. I would suggest testing this using something
> like netcat to make sure the tunnel is working. If you can connect to
> netcat with telnet and PostgreSQL is still not connecting then you may want
> to have a look at your pg_hba.conf configuration to make sure it is set up
> to accept connections from your SSH server.
>
>
>
> Jon
>
>
>
> *From: *Dave Cramer <davecramer(at)postgres(dot)rocks>
> *Date: *Tuesday, January 23, 2024 at 4:35 PM
> *To: *Juan Ignacio Fernigrini <juanfernigrini(at)gmail(dot)com>
> *Cc: *pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
> *Subject: *Re: ssh tunneling
>
>
>
>
>
> On Tue, 23 Jan 2024 at 16:06, Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
>
>
>
>
> On Tue, 23 Jan 2024 at 15:28, Juan Ignacio Fernigrini <
> juanfernigrini(at)gmail(dot)com> wrote:
>
> Good morning team,
>
>
>
> I hope this message finds you well.
>
>
>
> I am tasked with establishing a connection to my database using ODBC with
> SSH tunneling. Unfortunately, the current ODBC solution is not compatible.
> I have explored alternatives such as Devart, but it comes at a cost of
> $250. I am considering whether it would be more beneficial to invest this
> amount in developing the required feature within the existing open-source
> ODBC solution.
>
>
>
> Best regards,
> Juan Ignacio Fernigrini
>
>
>
> I'm not sure why psql odbc would not be able to use ssh tunneling. Can you
> expand upon that ?
>
> Dave Cramer
>
> www.postgres.rocks
>
>
>
> see What is an SSH Tunnel & SSH Tunneling?
> <https://www.ssh.com/academy/ssh/tunneling#:~:text=SSH%20tunneling%20is%20a%20method%20of%20transporting%20arbitrary,Private%20Networks%29%20and%20access%20intranet%20services%20across%20firewalls.>
>
>
>
>
> For details it is not part of the driver.
>
>
>
> Dave
>
>
>
>

--
Atte Juan I Fernigrini