PostgreSQL

AllowDateTimeOffset

Determines whether to use the DateTimeOffset type instead of DateTime when PgSqlDataReader returns a timestamptz value.

ApplicationName

Specifies the client application name.

Character Set

Specifies a character set used by the client. Actually, if this property is enabled, then the "SET NAMES <Charset>" query is executed on establishing a connection. Default value is an empty string. That means there is no action performed with charset on the client and on the server.

Connection Lifetime

Specifies the time span (in seconds), compared against a connection's creation time when it is returned to the pool; the connection is destroyed if this span is exceeded. The default value is 0.

Connection Timeout

Specifies the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.

Database

Specifies the name of the database. If this parameter is not specified, it is assumed that name of the database is same as user name.

Default Command Timeout

Specifies the default time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. 0 indicates no limit.

Default Fetch All

Ignores any value assigned to it. Do not use this parameter.

Enlist

Determines whether the connection is automatically enlisted in the current distributed transaction. The default value is true.

Force IPv4

Determines whether authentication by IPv6 address is allowed, or IPv4 address is always used.

Host

Specifies the name or IP address of the PostgreSQL server to which to connect.

Ignore Unnamed Parameters

Determines whether to treat the '?' character in the command text as an unnamed parameter.

Initial Schema

Specifies the name of the schema to be used once a connection is opened. You can change it later if you need. By default it is schema 'Public'.

Initialization Command

Specifies a database-specific command to execute after establishing the connection.

Integrated Security

Determines whether to use a secure authentication with single sign-on (GSSAPI or SSPI, depending on the server).

Join Statement Notices

Ignores any value assigned to it. Do not use this parameter.

Keep Alive

Specifies whether to send TCP keep-alive packets and the interval at which they are sent in seconds. Default value is 0, which means that the packets are not sent.

Keep Connected

Specifies the interval, in seconds, at which periodic ping requests are sent to PostgreSQL while the connection is idle to prevent the connection from being closed. The default value is 0, indicating that the calls are disabled.

Max Pool Size

Specifies the maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

Specifies the minimum number of connections allowed in the pool. The default value is 0.

Password

Specifies the password for the PostgreSQL login account.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Pooling

Draws the connection from the appropriate pool, or creates and adds it to the appropriate pool, when set to true. This is the default behavior.

Port

Specifies the port of the PostgreSQL database to which to connect. The default value is 5432.

Protocol

Specifies the Frontend/Backend Protocol version. Available values are 2 and 3. Set the parameter to 2 for the protocol version 2.0 or to 3 for protocol version 3.0. Can be applied only for PostgreSQL server versions 7.4 or higher, for earlier versions of PostgreSQL this parameter is ignored. To execute several statements in the same query set procol to 2 version. The default value is 3.

Proxy Host

Specifies the host name or IP address of the proxy server.

Proxy Password

Specifies the password for the proxy server account.

Proxy Port

Specifies the port number of the proxy server. The default value is 3128.

Proxy User

Specifies the proxy server account name.

Run Once Command

Specifies a database-specific command to execute after establishing the connection. Unlike Initialization Command, it is not executed for connections obtained from the connection pool.

SSH Authentication Type

Specifies the client's SSH authentication methods.

SSH Cipher List

Specifies the list of ciphers that the client agrees to use, separated by colons. Two modes of block ciphering are supported: Cipher-block chaining (CBC) and Counter (CTR).

The following ciphers are available for SSH connections in the CBC mode:

 
In the CTR mode the AES ciphers are used.

You can use ALL keyword to indicate whole set of ciphers. To exclude certain cipher from the set use "-" sign. For instance, the value of CipherList parameter "ALL-Blowfish" means that any cipher but Blowfish can be used.

SSH Host

Specifies the name or IP address of the SSH server.

SSH Host Key

Specifies the location of the public key on the client side to verify the server host key during establishing connection. OpenSSH or IETF SECSH key files are supported. You may use such utilities as 'ssh-keygen.exe' or 'puttygen.exe' for generation of the corresponding public/private key pair.

SSH KeyExchange Algorithms

Specifies the algorithms to securely establish a shared encryption key between the client and the server.

SSH MAC Algorithms

Specifies the algorithms to verify the integrity and authenticity of data exchanged between the client and the server.

SSH Passphrase

Specifies the client key passphrase.

SSH Password

Specifies the user password on the SSH server.

SSH Port

Specifies the number of the port on the SSH server to connect.

SSH Private Key

Specifies the location of the client private key.

SSH Strict Host Key Check

Indicates whether the host key is verified during establishing connection.

SSH User

Specifies the user ID on the SSH server.

SSL CA Cert

Specifies the location of the authority SSL certificate.

SSL Cert

Specifies the location of the client SSL certificate.

SSL Cipher List

Specifies the list of ciphers that the client agrees to use.

SSL Key

Specifies the location of the user's private key.

SSL TLS Protocol

Determines the preferred TLS protocol version reported to a server when establishing a secure connection. The default value is "1.1" to avoid errors with older server versions, not supporting TLS 1.2. Acceptable values are "1.0", "1.1", "1.2" (without quotes).

SSLMode

Specifies the 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.

Target Session

Determines how the host to connect to is selected from the list when multiple hosts are specified in the Host connection string parameter.

Transaction Error Behavior

Determines how to handle errors that occur within a transaction.

Transaction Scope Local

Reuses a single internal connection when several connections share the same connection string (including "Transaction Scope Local=true;") within a scope of TransactionScope. The default value is false.

Unicode

Sets the client charset to UTF8 and converts client data according to this charset, when set to true. This is the default behavior.

UnpreparedExecute

Uses the unprepared execute mode by default, when set to true.

Use Session Timezone

Determines whether the current session's time zone is used to convert requested PostgreSQL date/time values.

User Id

Specifies the PostgreSQL login account.

Validate Connection

Specifies whether to validate connections that are being got from the pool.