skip to main content
DataDirect Connect Drivers : PostgreSQL Driver : Configuring Failover : Failover Properties
  
Failover Properties
The following table summarizes the connection properties that control how failover works with the PostgreSQL driver. See Connection Properties for details about configuring each property.
Table 56. Summary: Failover Properties for the PostgreSQL Driver
Property
Characteristic
AlternateServers
One or multiple alternate database servers. An IP address or server name identifying each server is required. Port number and the connection property DatabaseName are optional. If the port number is unspecified, the port number specified for the primary server is used. If a port number is unspecified for the primary server, the default port number of 5432 is used.
ConnectionRetryCount
Number of times the driver retries the primary database server, and if specified, alternate servers until a successful connection is established. The default is 5.
ConnectionRetryDelay
Wait interval, in seconds, between connection retry attempts when the ConnectionRetryCount property is set to a positive integer. The default is 1.
DatabaseName
Name of the database to which you want to connect.
LoadBalancing
Sets whether the driver will use client load balancing in its attempts to connect to the database servers (primary and alternate). If client load balancing is enabled, the driver uses a random pattern instead of a sequential pattern in its attempts to connect. The default is false (client load balancing is disabled).
PortNumber
Port listening for connections on the primary database server. This property is supported only for DataSource connections. The default port number is 5432.
ServerName
IP address or server name for the primary database server. This property is supported only for DataSource connections.
See Using Failover and Using Client Load Balancing for overviews of failover and client load balancing.