Postgresql – pgAgent doesn’t run on another database than “postgres”

pgadminpgagentpostgresql-9.3

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 !

Best Answer

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.

Related Question