Cannot Connect to server with SSLmode set to required.

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 PGA

Re: Cannot Connect to server with SSLmode set to required.

On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto 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

Re: Cannot Connect to server with SSLmode set to required.

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 connect

Re: Cannot Connect to server with SSLmode set to required.

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 Mo

Re: Expand/Collapse Nodes in Query Window

Hello, that looks to be referring to just begin/end if statements. I'm referring to any long list of data being selected in a parentheses (ie, WHERE ID Number IN (a, b, c, d, etc) where there might be hundreds or thousands of items. PGAdmin 3 used to have an expand/collapse button so you can see yo

Re: Expand/Collapse Nodes in Query Window

Hi Cody, The code folding in pgAdmin currently is not really in a very good state due to an upgrade of an underlying package(CodeMirror). We're continuously working to make it better. What you can do is mention your suggestion on the ticket I mentioned. On Mon, Jun 17, 2024 at 7:55 PM Cody Boorma

Re: Expand/Collapse Nodes in Query Window

Hi Cody, pgAdmin 3 is not supported. Only latest version of pgAdmin 4 is supported. On Mon, Jun 17, 2024 at 8:49 PM Cody Boorman wrote: > I don't have access to a github account with my organization. Can you > please add to the ticket on my behalf? I've copy/pasted a recap of the > issue along