PostgreSQL No connection could be made because the target machine actively refused

Sat Rai
Sat Rai used Ask the Experts™
on
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!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Doug WaltonDatabase Administrator

Commented:
Looks like you're doing everything right... maybe the firewall isn't configured quite right or the port isn't open on the machine itself.  What operating system is postgres running on?

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial