HeidiSQL / HeidiSQL

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi
https://www.heidisql.com/
GNU General Public License v2.0
4.81k stars 458 forks source link

Postgresql SSLmode #2046

Open xsakim opened 2 hours ago

xsakim commented 2 hours ago

I am currently working in an environment where the SSL mode of a PostgreSQL DBMS is enabled. Since this is a DBaaS product hosted in a cloud environment, it is not possible to disable SSL communication settings.

Although HeidiSQL provides an "ssluse" checkbox for SSL functionality, I have noticed that even when this checkbox is not selected, the actual protocol still uses TLS v1.3. Upon capturing network traffic, I confirmed that packets are being transmitted using TLS v1.3.

In my current environment, I need to use the TCP/IP protocol without SSL, but HeidiSQL does not appear to support this functionality. Other database tools offer an option to disable SSL mode, which makes them usable in my scenario.

Could you please consider supporting this feature in HeidiSQL, allowing users to disable SSL mode and use the TCP/IP protocol? Your support on this matter would be greatly appreciated.

ansgarbecker commented 2 hours ago

https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNECT-SSLMODE