public final Enum PGProperty

Specifies if number of rows, used during fetching rows of a result set, should be computed dynamically. Number of rows will be calculated by dividing maxResultBuffer size by max row size observed so far, rounded down. First fetch will have number of rows declared in defaultRowFetchSize. Number of rows can be limited by adaptiveFetchMinimum and adaptiveFetchMaximum. Requires declaring of maxResultBuffer and defaultRowFetchSize to work. Default value is false.

Specifies the highest number of rows which can be calculated by adaptiveFetch. Requires adaptiveFetch set to true to work. Default value is -1 (used as infinity).

Specifies the lowest number of rows which can be calculated by adaptiveFetch. Requires adaptiveFetch set to true to work. Default value is 0.

When using the V3 protocol the driver monitors changes in certain server configuration parameters that should not be touched by end users. The client_encoding setting is set by the driver and should not be altered. If the driver detects a change it will abort the connection.

The application name (require server version >= 9.0).

Assume the server is at least that version.

AuthenticationPluginClass

Specifies what the driver should do if a query fails. In autosave=always mode, JDBC driver sets a savepoint before each query, and rolls back to that savepoint in case of failure. In autosave=never mode (default), no savepoint dance is made ever. In autosave=conservative mode, savepoint is set for each query, however the rollback is done only for rare cases like 'cached statement cannot change return type' or 'statement XXX is not valid' so JDBC driver rollsback and retries

Use binary format for sending and receiving data if possible.

Comma separated list of types to disable binary transfer. Either OID numbers or names. Overrides values in the driver default set and values set with binaryTransferEnable.

Comma separated list of types to enable binary transfer. Either OID numbers or names

Cancel command is sent out of band over its own connection, so cancel message can itself get stuck. This property controls "connect timeout" and "socket timeout" used for cancel commands. The timeout is specified in seconds. Default value is 10 seconds.

Determine whether SAVEPOINTS used in AUTOSAVE will be released per query or not

The timeout value used for socket connect operations. If connecting to the server takes longer than this value, the connection is broken.

The timeout is specified in seconds and a value of zero means that it is disabled.

Specify the schema (or several schema separated by commas) to be set in the search-path. This schema will be used to resolve unqualified object names used in statements over this connection.

Specifies the maximum number of fields to be cached per connection. A value of 0 disables the cache.

Specifies the maximum size (in megabytes) of fields to be cached per connection. A value of 0 disables the cache.

Default parameter for java.sql.Statement#getFetchSize(). A value of 0 means that need fetch all rows at once

Enable optimization that disables column name sanitiser.

Specifies how the driver transforms JDBC escape call syntax into underlying SQL, for invoking procedures or functions. (backend >= 11) In escapeSyntaxCallMode=select mode (the default), the driver always uses a SELECT statement (allowing function invocation only). In escapeSyntaxCallMode=callIfNoReturn mode, the driver uses a CALL statement (allowing procedure invocation) if there is no return parameter specified, otherwise the driver uses a SELECT statement. In escapeSyntaxCallMode=call mode, the driver always uses a CALL statement (allowing procedure invocation only).

Group startup parameters in a transaction This is important in pool-by-transaction scenarios in order to make sure that all the statements reaches the same connection that is being initialized. All of the startup parameters will be wrapped in a transaction Note this is off by default as pgbouncer in statement mode

Force one of

• SSPI (Windows transparent single-sign-on)
• GSSAPI (Kerberos, via JSSE)

After requesting an upgrade to SSL from the server there are reports of the server not responding due to a failover without a timeout here, the client can wait forever. The pattern for requesting a GSS encrypted connection is the same so we provide the same timeout mechanism This timeout will be set before the request and reset after

Enable mode to filter out the names of database objects for which the current user has no privileges granted from appearing in the DatabaseMetaData returned by the driver.

Specifies the name of the JAAS system or application login configuration.

Flag to enable/disable obtaining a GSS credential via JAAS login before authenticating. Useful if setting system property javax.security.auth.useSubjectCredsOnly=false or using native GSS with system property sun.security.jgss.native=true

The Kerberos service name to use when authenticating with GSSAPI. This is equivalent to libpq's PGKRBSRVNAME environment variable.

If this is set then the client side will bind to this address. This is useful if you need to choose which interface to connect to.

Whether to include full server error detail in exception messages.

When connections that are not explicitly closed are garbage collected, log the stacktrace from the opening of the connection to trace the leak source.

This property is no longer used by the driver and will be ignored.

This property is no longer used by the driver and will be ignored.

Specify how long to wait for establishment of a database connection. The timeout is specified in seconds.

Specifies size of buffer during fetching result set. Can be specified as specified size or percent of heap memory.

Specify 'options' connection initialization parameter. The value of this parameter may contain spaces and other special characters or their URL representation.

Password to use when authenticating.

Database name to connect to (may be specified directly in the JDBC URL).

Hostname of the PostgreSQL server (may be specified directly in the JDBC URL).

Port of the PostgreSQL server (may be specified directly in the JDBC URL).

Specifies which mode is used to execute queries to database: simple means ('Q' execute, no parse, no bind, text mode only), extended means always use bind/execute messages, extendedForPrepared means extended for prepared statements only, extendedCacheEverything means use extended protocol and try cache every statement (including Statement.execute(String sql)) in a query cache.

This mode is meant for debugging purposes and/or for cases when extended protocol cannot be used (e.g. logical replication protocol)

Sets the default threshold for enabling server-side prepare. A value of -1 stands for forceBinary

Specifies the maximum number of entries in cache of prepared statements. A value of 0 disables the cache.

Specifies the maximum size (in megabytes) of the prepared statement cache. A value of 0 disables the cache.

Force use of a particular protocol version when connecting, if set, disables protocol version fallback.

Quote returning columns. There are some ORM's that quote everything, including returning columns If we quote them, then we end up sending ""colname"" to the backend which will not be found

Puts this connection in read-only mode.

Connection parameter to control behavior when Connection#setReadOnly(boolean) is set to true.

Socket read buffer size (SO_RECVBUF). A value of -1, which is the default, means system default.

Connection parameter passed in the startup message. This parameter accepts two values; "true" and "database". Passing "true" tells the backend to go into walsender mode, wherein a small set of replication commands can be issued instead of SQL statements. Only the simple query protocol can be used in walsender mode. Passing "database" as the value instructs walsender to connect to the database specified in the dbname parameter, which will allow the connection to be used for logical replication from that database.

Parameter should be use together with PGProperty#ASSUME_MIN_SERVER_VERSION with parameter >= 9.4 (backend >= 9.4)

Configure optimization to enable batch insert re-writing.

Socket write buffer size (SO_SNDBUF). A value of -1, which is the default, means system default.

Service name to use for additional parameters. It specifies a service name in "pg_service .conf" that holds additional connection parameters. This allows applications to specify only a service name so connection parameters can be centrally maintained.

Socket factory used to create socket. A null value, which is the default, means system default.

The String argument to give to the constructor of the Socket Factory.

The timeout value used for socket read operations. If reading from the server takes longer than this value, the connection is closed. This can be used as both a brute force global query timeout and a method of detecting network problems. The timeout is specified in seconds and a value of zero means that it is disabled.

Control use of SSL: empty or true values imply sslmode==verify-full

File containing the SSL Certificate. Default will be the file postgresql.crt in $HOME/.postgresql (*nix) or %APPDATA%\postgresql (windows).

Classname of the SSL Factory to use (instance of javax.net.ssl.SSLSocketFactory).

The String argument to give to the constructor of the SSL Factory.

Classname of the SSL HostnameVerifier to use (instance of javax.net.ssl.HostnameVerifier).

File containing the SSL Key. Default will be the file postgresql.pk8 in $HOME/.postgresql (*nix) or %APPDATA%\postgresql (windows).

Parameter governing the use of SSL. The allowed values are disable, allow, prefer, require, verify-ca, verify-full. If ssl property is empty or set to true it implies verify-full. Default mode is "require"

The SSL password to use in the default CallbackHandler.

The classname instantiating javax.security.auth.callback.CallbackHandler to use.

After requesting an upgrade to SSL from the server there are reports of the server not responding due to a failover without a timeout here, the client can wait forever. This timeout will be set before the request and reset after

File containing the root certificate when validating server (sslmode = verify-ca or verify-full). Default will be the file root.crt in $HOME/.postgresql (*nix) or %APPDATA%\postgresql (windows).

Specifies the name of the SSPI service class that forms the service class part of the SPN. The default, POSTGRES, is almost always correct.

Bind String to either unspecified or varchar. Default is varchar for 8.0+ backends.

Enable or disable TCP keep-alive. The default is false.

Specifies the length to return for types of unknown length.

Use SPNEGO in SSPI authentication requests.

Username to connect to the database as.

Factory class to instantiate factories for XML processing. The default factory disables external entity processing. Legacy behavior with external entity processing can be enabled by specifying a value of LEGACY_INSECURE. Or specify a custom class that implements org.postgresql.xml.PGXmlFactoryFactory.