Thread: Multiple Hosts connection with ODBC Driver

We currently have a primary/standby setup and we currently need to run an application that uses connections via ODBC.

Does somebody knows if we can with ODBC, like libpq, use a connection string or dns entry with multiple hosts? We would like to connect automatically to the primary server like the way we can with native libpq.

Reference: https://www.postgresql.org/docs/10/libpq-connect.html#LIBPQ-MULTIPLE-HOSTS

Near the page end:  target_session_attrs=read-write

Bruno Lavoie