AWS – New Open-Source AWS Advanced PostgreSQL ODBC Driver now available for Amazon Aurora and RDS
The Amazon Web Services (AWS) ODBC Driver for PostgreSQL is now generally available for use with Amazon RDS and Amazon Aurora PostgreSQL-compatible edition database clusters. This database driver provides support for faster switchover and failover times, Aurora Limitless, and authentication with AWS Secrets Manager, AWS Identity and Access Management (IAM), or Federated Identity.
The Amazon Web Services (AWS) ODBC Driver for PostgreSQL is a standalone driver and supports RDS and community PostgreSQL and Amazon Aurora PostgreSQL. You can install the aws-pgsql-odbc package for Windows, Mac or Linux by following the Getting Started instructions on GitHub. The driver relies on monitoring the database cluster status and being aware of the cluster topology to determine the new writer. This approach reduces switchover and failover times from tens of seconds to single digit seconds compared to the open-source driver.
The AWS Advanced MySQL PostgreSQL driver is released as an open-source project under the Library General Public Licence, or LGPL.
Read More for the details.