I am making a job in postgresql using pgagent when I run my job it says coudn't connect to db

Asked Sep 25 '20 at 20:06

Active Sep 26 '20 at 12:05

Viewed 613 times

I am making a job in postgresql using pgagent when I run my job it says coudn't connect to db. Can any one guide me what is the issue? I tried to find on internet but could not find anything beneficial. I have created my own Database named 'TestDB' . I have only one connection string in pgpass.conf

which is localhost:5432:postgres:postgres:test

edited Sep 26 '20 at 12:05

alexherm

1,362
2
18
31

asked Sep 25 '20 at 20:06

Vijay Kumar Khatri

Do you actually have Postgres server running? Can you connect to it using psql? If your database is "TestDB", then why do you have the database as "postgres"? If you're on Linux, your pgpass.conf must be 0600. – Tim Roberts Sep 25 '20 at 21:12
Agree, there is something wrong with your connection string and database name. – alexherm Sep 25 '20 at 22:47
@alexherm I added connection string and correct database name but it still did not work – Vijay Kumar Khatri Sep 26 '20 at 11:12
@TimRoberts Postgres server is running and I can it with pgadmin 4 . I have created new DB named 'Test DB' but pgpass.conf has this connection string as default. I am using Windows. I changed connection string to 'localhost:5432:TestDB:postgres:test' as well but same issue – Vijay Kumar Khatri Sep 26 '20 at 11:15
@alexherm you were right there was an issue with connection string.Thanks – Vijay Kumar Khatri Sep 29 '20 at 18:57
Go ahead and post the corrected string for others to see. – alexherm Sep 29 '20 at 19:01
1

Connection String="user=postgres host=localhost port=5432 dbname=TestDB password=test" – Vijay Kumar Khatri Sep 29 '20 at 20:36

I am making a job in postgresql using pgagent when I run my job it says coudn't connect to db

0 Answers0