All of the sudden, after the last update and having recently moved over from Sockets to Resource Manager, my staging/testing environment can lo longer connect to the remote DB (A Linode Managed Database server) and gets this message:
no pg_hba.conf entry for host "IP ADDRESS", user "linpostgres", database "staging", SSL off
It was working a couple of days ago when i first switch over to Resource Manager.
I get the same message whether its me trying to connect to the DB in DB manager (uses my own IP) or if its the app trying connect (IP address of web server)
PLEASE NOTE: I have updated my ip address and the server IP address in the managed DB on Linode. ALSO, I can remotely connect to the DB through Navicat on my PC using the exact same host and login details (No SSL or SSH).
I dont think its an issue with the pg_hba file perse, as if it was I wouldn’t be able to remotely connect at all…but i easily can on Navicat or any other SQL admin GUI.
I have also completely deleted the staging web server and created a whole new target but the problem still remains.
Can anyone PLEASE help? I was wanting to push out an update this weekend but with my staging environment not working and now unusable, I certainly can’t touch anything on production.
FWIW, Windows 11, Node.JS, Docker, Resource Manager and Linode