Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pgagent]

pgAgent is a job scheduling agent for PostgreSQL and is a part of pgAdmin.

Introduced with pgAdmin III v1.4, pgAgent is capable of running multi-step batch/shell and SQL tasks on complex schedules.

22 questions
4
votes
1 answer

Why doesn't pgAgent run my job every minute?

I have a job and I set the schedule to run every minute. However, it always skips the next minute after finishing the process, even when the process ends in less than one minute. The problem is that data is still arriving during that minute so…
Juan Carlos Oropeza
  • 427
  • 2
  • 8
  • 20
2
votes
1 answer

PostgreSQL: how to query statistics of a step in pg_agent?

PgAdmin shows statistics of each run of a step of pg_agent (job). The list details the run ID, status, result, start & end & duration. The following is how it looks: How to get it by query command ?
Rino
  • 219
  • 1
  • 6
  • 13
2
votes
1 answer

pgAgent service for PostgreSQL does not run

OS: Windows 10 PostgreSQL 11.4 I Installed PgAgent with Stackbuilder setup. In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start pgAdmin service from there I get this error message: The…
tomatoeshift
  • 143
  • 1
  • 1
  • 9
2
votes
0 answers

pgAgent Job Slows Over Time

I'm running a scheduled job using pgAgent on PostgresSQL 9.5. The duration of this job seems to grow over subsequent runs, and this slow down doesn't appear to be a direct relationship to the amount of data processed each time. The job itself is a…
Matt
  • 121
  • 1
2
votes
1 answer

Auto start pgAgent

When my windows server 2008 start, both services postgres and pgAgent start because they are automatic. But if my db is frozen and I need to restart the postgres service, the pgAgent is also stoped, but when postgres restart, pgAgent doesn't. So I…
Juan Carlos Oropeza
  • 427
  • 2
  • 8
  • 20
2
votes
1 answer

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

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 !
Corentin Villa
  • 41
  • 5
2
votes
1 answer

pgAgent not working on linux (Ubuntu 14.04)

I am running Postgres 9.3 on Ubuntu 14.04 and I am unable to get pgAgent daemon/service to run. I have confirmed that the daemon is not running using service --status-all. When trying to run pgagent (whilst logged in as the only user in ubuntu)…
Greg
  • 381
  • 6
  • 13
1
vote
0 answers

PgAdmin4 cant find pgagent as an extension MacOS

I installed pgagent using EnterpriseDB's installer on MacOS. However, pgagent doesn't show up in pgadmin after the installation. Even when I try to manually add pgagent as an extension, I get the error: extension "pgagent" is not available and that…
champa
  • 11
  • 2
1
vote
1 answer

pgAgent unwanted delay between jobs start time

I've been trying to make jobs running continuosly, so after previous run is done, the next one starts immediately. I made some initial success with following trigger: CREATE or replace FUNCTION continous_jobs() RETURNS trigger AS $$ BEGIN …
sh4rkyy
  • 149
  • 5
1
vote
1 answer

How to determine the version of pg_agent installed?

How do I determine the version of pg_agent installed? Is it queriable with SQL just like checking PostgreSQL version / PostGIS version ?
Rino
  • 219
  • 1
  • 6
  • 13
1
vote
0 answers

What security concerns are with allowing pgAgent to database users?

I have a customer who would like to use pgagent, however, as a DBA I have security concerns with pgagent having the ability to execute shell scripts from within the Postgres instance. Can anybody tell me how I might prevent pgagent from running…
vibrantsparrow
  • 11
  • 1
1
vote
1 answer

PostgreSQLpgagent "Running at: is not runing"

I have a problem to run pgAgent job for PostgreSQL 9.6 under ubuntu 16.04. The job is never executed. I already configured .pgpass and added: localhost:5432:*:postgres:mypass Also modified the permission for .pgpass: $ touch ~/.pgpass $ chmod 0600…
Eyla
  • 219
  • 7
  • 15
1
vote
1 answer

What is the pgAgent service account?

Im installing pgAgent using Stack Builder. In one step ask me for service account. Should I use PC, Domain or DB user? Or create a new one? I try using my DOMAIN\my.user.name also using the postgres user and return same error. I dont have the…
Juan Carlos Oropeza
  • 427
  • 2
  • 8
  • 20
1
vote
2 answers

Routinely deleting aged postgresql rows via cron

I have a Django website with a postgresql 9.3.10 backend. The website contains dynamic user-generated content (think of it as a form of 9gag). There are some tables from which I routinely delete aged rows. The database is called dbname and I log…
Hassan Baig
  • 2,079
  • 8
  • 31
  • 44
1
vote
0 answers

PgAgent unable to run a job

I am running PostgreSQL 9.4.5 on Ubuntu 14.04.3. I am trying to set up pgAgent job but I keep getting this error: DEBUG: Creating DB connection: user=xxx host=localhost port=5432 dbname=otherdb password=pass DEBUG: Allocating new connection to…
errata
  • 285
  • 1
  • 2
  • 8
1
2