Share via

Unable connect to AWS Aurora PostgreSQL 14.7 using Azure data factory

KC2022JAN-0951 61 Reputation points
2023-08-14T07:49:12.25+00:00

My developer was use ADF to copy data from AWS Aurora PostgreSQL during UAT.

However start deploy in Production with same steps but facing error below:-

Error Code : 9603

Details : ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed.

ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed. ERROR [28000] [Microsoft][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]FATAL: VFATAL: no pg_hba.conf entry for host"x.x.x.x", user"username", database"databasename", no encryption(File auth.c; Line 558: Routine ClientAuthentication;) Activity ID: a1234b56-c7d8-9012-f34g-h5i678901jkl.

I have no idea what to looking for and what I found is different version of PostgreSQL as UAT is 14.5 but in production is 14.7.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2023-08-14T21:17:56.04+00:00

    Hello KC2022JAN-0951,

    The issue is specific to the PostgreSQL ODBC diver and the SHIR version.

    The PostgreSQL ODBC should be compatible with the SHIR version.

    Please compare SHIR and ODBC driver versions in your UAT and prod and upgrade them accordingly?

    I hope this helps. Please let me know if you have any further questions.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.