Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)FrancésItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for PostgreSQL Wire Protocol Driver User's Guide Release 8.0.2

Failover tab

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for PostgreSQL Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
    • Version string information
      • getFileVersionString function
    • Data Types
      • Partially and Unsupported Data Types
      • Using the XML Data Type
      • Retrieving data type information
    • Driver specifications
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
    • Power BI (Windows only)
  • Configuring and connecting to data sources
    • Environment settings
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring the driver using the GUI
      • General tab
      • Advanced tab
      • Security tab
      • Failover tab
      • Pooling tab
    • Using a connection string
    • Additional configuration methods for UNIX and Linux
      • Configuration through the system information (odbc.ini) file
        • Sample default odbc.ini file
      • DSN-less connections
        • Sample odbcinst.ini file
      • File data sources
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • Authentication
      • User ID/password authentication
      • Kerberos authentication
      • Certificate-based authentication
      • Microsoft Entra ID authentication
    • TLS/SSL encryption
      • Certificates
      • TLS/SSL server authentication
        • Using SQL_COPT_INMEMORY_TRUSTSTORECERT
        • Importing root certificates into the Windows certificate store
          • Importing root certificates using Certificate Import Wizard
          • Importing root certificates using a PowerShell script
      • TLS/SSL client authentication
      • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
      • Designating an OpenSSL library
    • Failover support
      • Configuring failover
      • Guidelines for primary and alternate servers
    • DataDirect connection pooling
    • Performance considerations
  • Additional features and functionality
    • Using IP addresses
    • User-defined function results
    • Persisting a result set as an XML data file
      • Using the Windows XML Persistence Demo tool
      • Using the UNIX/Linux XML Persistence Demo tool
    • Using Arrays of Parameters
    • Packet logging
  • Connection option descriptions
    • Alternate Servers
    • Application Using Threads
    • Authentication Method
    • Azure Tenant ID
    • Batch Mechanism
    • Call Escape Behavior
    • Client SSL Certificate
    • Client SSL Key
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • CryptoLibName
    • Crypto Protocol Version
    • Data Source Name
    • Database Name
    • Description
    • Enable FIPS
    • Enable Keyset Cursors
    • Enable SQLDescribeParam
    • Encryption Method
    • Extended Column MetaData
    • Extended Options
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch Ref Cursor
    • Fetch Size
    • Fetch TSWTZ as Timestamp
    • Fetch TWFS as Time
    • GSS Client Library
    • Host Name
    • Host Name In Certificate
    • IANAAppCodePage
    • Initialization String
    • Key Password
    • Key Store
    • Key Store Password
    • Keyset Cursor Options
    • Load Balance Timeout
    • Load Balancing
    • Login Timeout
    • Max Char Size
    • Max Long Varchar Size
    • Max Pool Size
    • Max Varchar Size
    • Min Pool Size
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • Port Number
    • Proxy Host
    • Proxy Mode
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Query Timeout
    • Report Codepage Conversion Errors
    • Service Principal Name
    • Show Selectable Tables
    • SSLLibName
    • TCP Keep Alive
    • Transaction Error Behavior
    • Trust Store
    • Trust Store Password
    • Unbounded Numeric Precision
    • Unbounded Numeric Scale
    • Use Declare Fetch
    • User Name
    • Validate Server Certificate
    • XML Describe Type
  • Copyright
Table of Contents

Failover tab

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 27, 2024
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • PostgreSQL 8.0
    • Documentation

The Failover tab allows you to specify failover data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.

Figure 1. Failover tab

The Failover Tab of the ODBC PostgreSQL Driver Setup dialog box

Connection Options: Failover Default
Load Balancing Disabled
Connection Retry Count 0
Connection Retry Delay 3
Alternate Servers No default value
Failover Mode 0 - Connection
Failover Granularity 0 - Non-Atomic
Failover Preconnect Disabled
Related Links
  • Configuring the driver using the GUI
TitleResults for “How to create a CRG?”Also Available inAlert