'Not able to connect local postgres instance from Airflow

I am trying to connect to a source DB from Airflow so that I can design data pipeline from source to destination. But whenever I try to establish a new postgres connection from Airflow it is throwing error.

The postgres instance is installed in my local and running on 5434 port.

I am running Airflow from Docker.

My postgressql.conf

enter image description here

My pg_hba.conf

enter image description here

Airflow connnection window

enter image description here

With port 5432:

enter image description here

Port and config details :

enter image description here

pythonpython-3.xpostgresqlairflow


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions