![]() The maximum number SQL statements that can be automatically prepared at any given point. Tcp KeepAlive Time must be non-zero as well. The interval, in seconds, between when successive keep-alive packets are sent if no acknowledgement is received. Use of this option is discouraged, use KeepAlive instead if possible. The number of seconds of connection inactivity before a TCP keepalive query is sent. Whether to use TCP keepalive with system defaults if overrides isn't specified. The number of seconds of connection inactivity before Npgsql sends a keepalive query. 1 skips the wait, 0 means infinite wait. The time to wait (in milliseconds) while trying to read a response for a cancellation request for a timed out or cancelled query, before terminating the attempt and generating an error. 1 uses CommandTimeout, 0 means no timeout. The time to wait (in seconds) while trying to execute an internal command before terminating the attempt and generating an error. The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. This is useful in clustered configurations to force load balancing between a running server and a server just brought online. Connections which have exceeded this value will be destroyed instead of returned from the pool. The total maximum lifetime of connections (in seconds). How many seconds the pool waits before attempting to prune idle connections that are beyond idle lifetime (see Connection Idle Lifetime). The time (in seconds) to wait before closing idle connections in the pool if the count of all connections exceeds Minimum Pool Size. ![]() Whether connection pooling should be used. When enabled, parameter values are logged when commands are executed. When enabled, PostgreSQL error and notice details are included on PostgresException.Detail and PostgresNotice.Detail. The Kerberos realm to be used for authentication. The Kerberos service name to be used for authentication. Gets or sets a Boolean value that 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. Whether to use integrated security to log in (GSS/SSPI). Whether to check the certificate revocation list during authentication. Location of a CA certificate used to validate the server certificate. Password for a key for a client certificate. ![]() Location of a client key for a client certificate to be sent to the server. Location of a client certificate to be sent to the server. ![]() Whether to trust the server certificate without validating it. See docs for possible values and more info. Path to a PostgreSQL password file (PGPASSFILE), from which the password is taken.Ĭontrols whether SSL is used, depending on server support. Not required if using IntegratedSecurity. If the value begins with a slash, it is used as the directory for the Unix-domain socket (specifying a Port is still required). Multiple hosts may be specified, see the docs for more info. Specifies the host name - and optionally port - on which PostgreSQL is running. For more information, see the official doc page on connection strings.īelow are the connection string parameters which Npgsql understands, as well as some standard PostgreSQL environment variables. Values containing special characters (e.g. Connection strings have the form keyword1=value keyword2=value and are case-insensitive. To connect to a database, the application provides a connection string which specifies parameters such as the host, the username, the password, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |