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!!