pgAgent doesn't run on another database than "postgres"

Question

I run a postgreSQL 9.3.3 database and I want to do some automatic Tasks with pgAgent, but it doesn't run on another database than "postgres" db. What can I do to run pgAgent on another db ?

thanks !

score 2 · Answer 1 · edited Feb 20 '18 at 14:21

2

The solution is that the maintenance DB's server (when you right click on server --> properties --> the 5th row) is postgres and it might be the other database where you want to run pgagent jobs.

edited Feb 20 '18 at 14:21

LowlyDBA - John M

11,059
11
45
63

answered Dec 04 '15 at 15:49

Corentin Villa

41
5

pgAgent doesn't run on another database than "postgres"

1 Answers1