Please look the picture below for more information on the SSL Connection Query: [image: Query-Run-Navica-02t.png] The connection from Navicat is marked with blue line and checks...
Regards, Surya 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 >> >
