Postgresql DB configured with ssh

Question

Postgresql DB configured with ssh

chanykf opened this issue 2 years ago · 4 comments

If the database is configured with ssh, how can I cope with it when handling the connection with PostgresClientKit? Your advice is appreciated. Thank you!

Answer 1 · 2023-06-23T19:05:14.000Z

Does this help?

https://www.postgresql.org/docs/current/ssh-tunnels.html

I haven't tried using PostgresClientKit with an SSH tunnel, but I don't see any reason it wouldn't work.

Any reason you can't use SSL/TLS instead?

Answer 2 · 2023-06-23T23:50:00.000Z

Thank you for your prompt reply. The situation is that the project is at "proof of concept" stage, and we would like to explore some cost-effective alternatives, such as SSH. Yes, you are right, we definitely need SSL/TLS at the next stage. Once again, thank you for your advice!

Answer 3 · 2023-06-24T16:20:57.000Z

Just FYI, PostgreSQL supports the server using self-signed SSL/TLS certificates, which are free and easy to generate.

https://www.postgresql.org/docs/current/ssl-tcp.html#SSL-CERTIFICATE-CREATION

Answer 4 · 2023-06-25T00:59:57.000Z

Great! Will explore this option as well. Thanks!