connect to Postgresql with SSL

Question

I am attempting to connect to a postgresql database which uses SSL via my c# application. But I'm unable to work out what the correct connection string would be. Is anyone able to help?

        NpgsqlConnection postgresConn;
        public PostgreManager()
        {
            openConnection();
        }

        private void openConnection()
        {
            postgresConn = new NpgsqlConnection("Server=10.153.8.4;Port=5432;Database=au_wa_jpc;User Id=readonly;Password=myPass;");
            postgresConn.Open();

        }

Edit:

I have attempted to use Ssl Mode=Require; in the connection string, however it throws the following exception.

An unhandled exception of type 'System.IO.IOException' occurred in Npgsql.dll

Additional information: TlsClientStream.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.

. The specified hostname was not present in the certificate.

Laurenz Albe · Accepted Answer · 2016-08-18 03:30:43Z

48

As described in the documentation here and here, you'll have to use SSL Mode=Require;Trust Server Certificate=true in your connection string.

edited Aug 18, 2016 at 3:30

answered Aug 18, 2016 at 3:05

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Miki Over a year ago

I wouldn't use Trust Server Certificate=true in production. You should pass Root Certificate and SSL Mode=VerifyFull instead. Refer to npgsql.org/doc/security.html#encryption-ssltls

Laurenz Albe Over a year ago

@Miki If you have to be concerned about man-in-the-middle attacks, definitely.

ccoutinho · Accepted Answer · 2022-07-20 18:42:23Z

0

What worked for me was reading this article.

PostgreSQL (SQL Authentication):

Server=127.0.0.1;Port=5432;Database=myDataBase;User ID=myUsername;Password=myPassword; SSL=TrueOrFalse;SslMode=RequireORDisable;

Server=IP Address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword; SSL=TrueOrFalse;SslMode=RequireORDisable;

The accepted answer did not work for me! It was rather this what worked:

SSL=TrueOrFalse;SslMode=RequireORDisable;

The following connection string is working for me - not in a C# project though:

"postgresql://<USER>:<PASSWORD>@$<POSTGRES_HOST>/<POSTGRES_DATABASE>?ssl=true&sslmode=require"

answered Jul 20, 2022 at 18:42

ccoutinho

4,7926 gold badges53 silver badges59 bronze badges

Collectives™ on Stack Overflow

connect to Postgresql with SSL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related