Please look into this. [image: Navicat-Connection-Settings.png] This is the connection setting on Navicat for the same server We've been successfully connect with SSLmode require.
With this connection, I run the query below: [image: Query-Run-Navicat.png] The blue marked connection is the connection with Navicat Client with SSL enabled connection. On Mon, Jun 17, 2024 at 3:14 PM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayru...@gmail.com> wrote: > >> Hi Support Team, >> >> We had PostgreSQL server PostgreSQL 14.12 on x86_64-pc-linux-gnu, >> compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit that runs >> with SSL Mode connection activated and we are enforcing ssl connection on >> it, >> >> When we try to connect to the server using local installed PGAdmin4 v8.8, >> we encounter this error *"Unable to connect to server:connection is bad: >> sslmode value "require" invalid when SSL support is not compiled in"* >> >> [image: image.png] >> >> Mean while when we try to connect from the same PC/Laptop using other 3rd >> party client software like Navicat, it can connect flawlessly with no >> problem at all even with SSLmode set to require. >> > While testing with other clients, how did you confirm that the connection > is secured? Does it show the SSL connection info? > >> >> FYI, the PGAdmin4 is running on web mode on Windows 11, that we run using >> this command: >> [image: image.png] >> >> Could you please take a look and help us to troubleshoot? >> >> Regards, >> Surya >> >
