0

Why pgAdmin creates a new pgAgent job only on the Postgres db even though I specify the setting on another db?

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228
teosantoro
  • 15
  • 1
  • 4

1 Answers1

1

Because the administration of pgAgent is stored inside the schema pgagent in the database "postgres". This has nothing to do with the database where the job will be executed.

Frank Heikens
  • 117,544
  • 24
  • 142
  • 135
  • Thanks for your reply. What I meant is that the job is executed only if the attribute "jstdbname" of "pgagent.pga_jobstep" (in the postgres db) is set to 'postgres' and not if it is set on the db that we are interested – teosantoro Mar 01 '11 at 14:19
  • That could be a permission problem. Does the user that executes the job, have the correct permissions? Check the database logfiles. – Frank Heikens Mar 01 '11 at 14:36
  • 1
    I solved it. The problem was that when I started pgagent, didn't set the "dbname = postgres" but as our db. – teosantoro Mar 01 '11 at 14:37
  • Thanks @teosantoro your comment saved me! – Egidi Jul 27 '16 at 09:01