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 Server- ...

    • 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 Start dbForge Products with Logging for Studios, Standalone Tools, and MiniTools

      If a dbForge product crashes or becomes unresponsive upon startup, logging is required for a detailed record of failures and issues. This guide helps you launch dbForge products with logging enabled to capture essential information for ...