Questions tagged [pgagent]
pgAgent is a job scheduling agent for PostgreSQL and is a part of pgAdmin.
24
questions
1
vote
0
answers
45
views
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 ...
- 11
0
votes
0
answers
36
views
pgAgent jobs do not run on databases other than default "postgres"
I am having a problem where I can only run pgagent jobs in default postgres database. I have a remote connection to another server and want to run pgagent jobs in a different database. Do I need to ...
0
votes
1
answer
53
views
How to fix PgAgent stuck on "r" on batch step errors?
On windows (10,11 and windows server 2022).
With PostgreSQL 14 and 15.
Pgagent is running as a service.
It runs SQL jobs and access pgpass correctly to run jobs as Local on multiple DBs.
It also ...
- 45
0
votes
1
answer
1k
views
Using pgagent with docker?
I wanted to dive into the world of postgresql so I installed both postgresql and pgadmin using docker (with the portainer web ui) and I found out that for automatic jobs you gotta install pgagent too ...
- 11
1
vote
1
answer
161
views
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 ...
- 129
1
vote
1
answer
170
views
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 ?
- 199
1
vote
1
answer
732
views
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 ...
- 199
2
votes
1
answer
10k
views
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 ...
- 143
0
votes
0
answers
1k
views
Unable to start PostgreSQL service after pgAgent installation
I had Postgre running just fine on my Windows 10 (64-bit).
Then I tried to install pgAgent via the stackbuilder for postgres. I got some error that it was not able to create a .conf file under %\...
- 143
0
votes
1
answer
2k
views
How can I run a pgAgent job every 10 second?
I have a PostgreSQL 11.3 Database. I installed pgAgent for creating jobs. Now I want to run my job every 10 second, but in GUI there is possibility to write with precision of minutes, not with ...
- 103
0
votes
0
answers
1k
views
PostgreSQL 11 and pgagent connection string issue
On PostgreSQL 11 running on Windows 2012 server, I created a job with pgagent and pgAdmin4.
In the step, in connection string I used the password parameter and it works.
Instead, I would like to use ...
- 207
1
vote
0
answers
111
views
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 ...
- 11
1
vote
1
answer
5k
views
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 ...
- 209
1
vote
0
answers
402
views
Can not run pgAgent as daemon in CentOS 6.6
I have a server with CentOS 6.6 & postgresql 9.5.
I have successfully setup the pgAgent from source code in postgresql website mentioned, but when I start it, I got error: Error: Cannot get the ...
- 11
4
votes
1
answer
2k
views
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 ...
1
vote
1
answer
4k
views
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 ...
2
votes
0
answers
97
views
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 ...
- 121
1
vote
2
answers
4k
views
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 ...
- 1,939
2
votes
1
answer
2k
views
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, ...
-1
votes
1
answer
465
views
How put repeat jobs in pgAgent
I have several data sources and create a C# app to connect to each one, download the data and insert into postgres.
That create a Data Pool and I create a Timer Event to execute a store procedure to ...
2
votes
1
answer
2k
views
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 !
2
votes
1
answer
4k
views
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 ...
- 371
1
vote
0
answers
2k
views
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 ...
- 285
0
votes
3
answers
5k
views
pgAgent Job's "last result" is continuously "running"
I am using PostgreSQL-9.3 on Ubuntu-14.04 and using "/usr/share/pgadmin3/pgagent.sql" I have configured my pgAdmin3 to use pgAgent. postgres is my maintenance Db and I have run the pgagent....
- 169