Search code examples
postgresqljob-schedulingpgadmin-4pgagent

pgagent couldn't get a connection to the database

I have created a job with steps, but when I click on "Run Now" in pgAdmin, nothing happens. Has anyone encountered and resolved this? Below is a screenshot for some details

my pgpass.conf

pgpass.conf

property

when I check the statistics, I have this:

status: failed output: Couldn't get a connection to the database!

here's my connection string: user=postgres host=127.0.0.1 port=5432 dbname=mydbname password=root

The Postgres Service is definitely running.

(PostgreSQL 15.3, pgadmin4)

I tried the local connection type but it didn't work, I also tried to change the pgpass.conf to mydbname but didn't work either.

Solution

  • Nevermind, I resolved it by not mentioning the password in the connection string and adding a line for my database in the pgpass.conf .