FireDAC TFDConnection DriverName and SSLMode Behavior After PostgreSQL ODBC Driver Upgrade in RAD Studio 12.0
0 reputation · 26 Jul 2023, 23:56 UTC
RAD Studio 12.0 supports FireDAC connections to PostgreSQL 15, typically requiring SSLMode=Require or Prefer in the connection parameters to match server encryption settings. The goal is to operate a low-traffic workload under the RAD Studio Community Edition license while keeping idle database connections to a minimum.
It is not documented whether TFDConnection automatically detects an upgraded PostgreSQL ODBC driver or whether DriverName must be updated manually after the driver changes. It is also unclear whether disabling pooling with Pooling=False and PoolSize=1 reliably closes idle connections without interfering with active SSL sessions.
Does TFDConnection require a manual DriverName update when the PostgreSQL ODBC driver version changes in RAD Studio 12.0? Is Pooling=False safe to use with SSLMode=Require for a low-traffic Community Edition deployment?