PostgreSQL SSL NuGets

PostgreSQL SSL NuGets

The SSL connection is implemented in the assemblies shipped with installation, but not in NuGet packages.

 

So, you should add to the project these assemblies:

 

 

 

 

 

 

 

 

There is ConnectionString Property related to SSL:

 

SSL CA Cert

The location of the authority SSL certificate.

Ssl Cert

The location of the client SSL certificate.

Ssl Cipher List

The list of ciphers that client agrees to use.

Ssl Key

The location of the user's private key.

Ssl Mode

SSL connection priority. May be Disable, Allow, Prefer, and Require. The default value is Disable, which means that only an unencrypted SSL connection will be attempted.

SSL TLS Protocol

Specifies the maximal TLS version to report to the server when establishing a connection. Supported values are "1.0", "1.1", and "1.2". The default value is "1.1".

 

See also: SslOptions Property

    • Related Articles

    • Password visible in Connection string ODBC PostgreSQL

      Please note that we cannot influence the behavior of MS Excel and in this case, if you do not want other users to see the password, then you should not save it in the DSN, but manually enter it every time you establish a connection.

    • Missing timestamp for a Comparison Execution

      The only option which allows to track time for operations in dbForge Data Compare for PostgreSQL is available in "Restore" section of Option window, and can be set to any needed timeframe:

    • Products compatibility/Requirements

      SQL Server Tools: dbForge Studio for SQL Server- https://docs.devart.com/studio-for-sql-server/getting-started/compatibility.html  SQL Complete- https://docs.devart.com/sqlcomplete/getting-started/requirements.html  Schema Compare for SQL ...

    • Help Content Manager Error

      If you are getting the following error:      This is not a critical error, you can ignore it and use online documentation: https://www.devart.com/dotconnect/postgresql/docs/     In order to avoid error, before installation of dotConnect press Modify ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...