Question: pgagent - not running jobs - pgpass file is correct - postgresql

Question

pgagent - not running jobs - pgpass file is correct - postgresql

Answers 1
Added at 2016-12-15 17:12
Tags
Question

I have Pgagent installed on my Debian OS. Along with Postgresql 9.4.

I have checked .pgpass file as this seems to be the most common cause for a job to not run.

host port 5432 database = * username = postgres password = xxxx.

for both local and the remote host. The database I'm trying to set a job for is on a remote host.

I made sure it was enabled. It's just a simple INSERT script that should repeat every 5 minutes.

No errors are being triggered that I can find. Any ideas of what would cause the job not to run at all - even when selecting 'run now'?

Answers to

pgagent - not running jobs - pgpass file is correct - postgresql

nr: #1 dodano: 2016-12-15 18:12

Check postgre db, pgAgent Catalog, pga_jobsteplog

enter image description here

Source Show
◀ Wstecz