Supplementary Pre-Install & Configuration Resources By Database

PostgreSQL

• Do OpenLink drivers connect to PostgreSQL?
  
• Which versions of PostgreSQL are supported by OpenLink drivers?
  
• How can I detect my PostgreSQL DBMS version?
  
• What is the PostgreSQL native client?
  
• When do I need the PostgreSQL native client?
  
• Where can I get the PostgreSQL native client?
  
• How do I configure the PostgreSQL native client?
  
• How do I create a Single-Tier DSN to connect to PostgreSQL?
  
• How do I create a standard (2-Tier) Multi-Tier DSN to connect to PostgreSQL?
  
• How do I create an application server (3-Tier) Multi-Tier DSN to connect to PostgreSQL?
  
• How do I create a JDBC Type 1 URL to connect to PostgreSQL?
  
• How do I create a JDBC Type 3 URL to connect to PostgreSQL?
  
• What value does the PGHOST environment variable pass?
  
• What value does the PGPORT environment variable pass?
  
• How do I monitor open database sessions associated with PostgreSQL ODBC connections?
  
• Where is the PostgreSQL error log?
  
• How do I dump the PostgreSQL error log?
  
• How do I find my PostgreSQL listening port?