SSL Mode in PGAdmin 1.18.1 - Mailing list pgadmin-support

From Colin Wright
Subject SSL Mode in PGAdmin 1.18.1
Date
Msg-id 8B1BFC8D82EB224EB9F29E47DC52474AA972F3@STGV-BUS01.thinkwhere.local
Whole thread Raw
Responses Re: SSL Mode in PGAdmin 1.18.1
List pgadmin-support

Hi,

I’ve been trying to set up SSL connections to our postgres databases but I’m coming across some difficulties with the way the settings are working with the latest version of PGAdmin.  Can someone tell me if these are known bugs with the use of SSL in PGAdmin 1.18.1 (windows 7), and if there are any work-arounds?  

 

The SSL drop-down is empty which I assume is a bug? It had a list of options in previous versions.

 

When I try to connect to a database that forces SSL (using a self-signed certificate) it is failing to connect because of being unable to validate the certificate.    Does this mean that PGAdmin is defaulting to either  “verify-ca” or “verify-all” SSL option?  Is there any way of changing this to “require” instead so that I don’t need to set up the server certificate on every PC running PGAdmin (given that the drop-down doesn’t have any options)?

 

In PGAdmin 1.18.0 and earlier there was a list of SSL settings on the properties tab of the details pane for the connection, including whether or not you were using an encrypted connection.  Is this information still available somehow as it can be useful confirmation that you are using an encrypted connection?

 

Thanks in advance for any tips and advice you can provide

 

Colin Wright

 


Colin Wright
Principal Developer

t: 01786 476060 (Office)
t: 01786 476083 (Direct Dial)
w:www.thinkwhere.com

Glendevon House
Castle Business Park
Stirling FK9 4TZ


This email and its attachments are private and confidential. If you believe you have received this email in error, please contact the sender immediately on 01786 476060. If you are not the intended recipient, you may not rely on, use or disclose this email or any attachments in any way.

thinkWhere Limited does not accept any liability for any damage that may be caused to the recipient's system or data by this email or any attachments. Please note that our email system may be subject to random monitoring by us. This Company accepts no liability for personal emails.

thinkWhere is a limited company registered in Scotland with Registered Number SC315349 and having its Registered Office at Glendevon House, Castle Business Park, Stirling, FK9 4TZ.

pgadmin-support by date:

Previous
From: Dave Barter
Date:
Subject: OSX UI Crash PG Admin 18.1.1
Next
From: Dave Page
Date:
Subject: Re: SSL Mode in PGAdmin 1.18.1