I have a postgresql instance and pgagent on windows server.
When I try to connect to a remote Linux version of postgresql through pgagent, it happens,but when I try to connect using pgagent job I get this error:
Couldn't get a connection to the database
Pgpass on the remote server is properly configured.