In PgAgent tried with Local connection as well as Remote connection with connection string, yet both are not connecting to the database. Able to connect to database and execute it query window but through the job it is not working. All permissions are there, yet not working. Below is the connection string used
host=localhost port=5432 dbname=testdb connect_timeout=10
