Sat Rai
asked on
PostgreSQL No connection could be made because the target machine actively refused
Hi,
I'm trying to connect my PostgreSQL to Skyvia, a cloud data integration tool. When attempting to do so, I encounter the error message of:
No connection could be made because the target machine actively refused it 127.0.0.1:5432
I have amended my postgres file to listen_Address = '*' as well as amend the pg_hba file to include the Skyvia ip address for access, as recommended, I've also tried setting the configuration to
host all all 0.0.0.0/0 md5
I've also set up an inbound rule on my firewall to allow connections to the port 5432, but still no luck.
Any ideas of where I'm going wrong would be greatly appreciated!!
I'm trying to connect my PostgreSQL to Skyvia, a cloud data integration tool. When attempting to do so, I encounter the error message of:
No connection could be made because the target machine actively refused it 127.0.0.1:5432
I have amended my postgres file to listen_Address = '*' as well as amend the pg_hba file to include the Skyvia ip address for access, as recommended, I've also tried setting the configuration to
host all all 0.0.0.0/0 md5
I've also set up an inbound rule on my firewall to allow connections to the port 5432, but still no luck.
Any ideas of where I'm going wrong would be greatly appreciated!!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Is Skyvia running on the local machine? If so the only other thing I can think of is to add something like this to pg_hba:
local all all md5
I've had some issues in the past with specifying IPs, maybe you could try "all" instead of "0.0.0.0/0", but it should do the same thing.