Failover Preconnect
- Last Updated: August 5, 2021
- 1 minute read
- DataDirect Connectors
- ODBC
- PostgreSQL 8.0
- Documentation
Failover Preconnect
Attribute
FailoverPreconnect (FP)
Purpose
Specifies whether the driver tries to connect to the primary and an alternate server at the same time.
This attribute applies only when Failover Mode is set to 1
(Extended Connection) or 2 (Select) and at least one alternate server is
specified.
The Alternate Servers option specifies one or multiple alternate servers for failover and is required for all failover methods.
Valid Values
0 | 1
Behavior
If set to 0 (Disabled), the driver tries to connect to an
alternate server only when failover is caused by an unsuccessful connection attempt or a
lost connection. This value provides the best performance, but your application typically
experiences a short wait while the failover connection is attempted.
If set to 1 (Enabled), the driver tries to connect to the
primary and an alternate server at the same time. This can be useful if your application is
time-sensitive and cannot absorb the wait for the failover connection to succeed.
Default
0 (Disabled)