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
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.
Nevermind, I resolved it by not mentioning the password in the connection string and adding a line for my database in the pgpass.conf .