Hi, I've been trying to connect Skyvia with PostgreSQL (Mac OS) and I've been getting the following issues:
First of all, I've been getting this message “skyvia postgresql connection could be made because the target machine actively refused it” when trying to connect with "local host"
I've done some troubleshooting and run the issue with Python and psycopg2. It connected with the PostgreSQL, which confirms it is not an issue with the firewall (switched off) or the Mac itself which could have not allowed for the connection (everything is open and it connects).
Nonetheless, the Skyvia still cannot connects with the PostgreSQL. Having tried the server "192.168.1.248" I go the following message : "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
Any ideas how can I solve this issue?
I have already gone through multiple pages and various ideas - edited the pg_hba.conf and postgresql.conf to enable the connection and restarted relevant databases.