Questions tagged [pgagent]

pgAgent is a job scheduling agent for PostgreSQL

Filter by
Sorted by
Tagged with
0
votes
1answer
29 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 ...
0
votes
0answers
137 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 ...
1
vote
0answers
34 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 ...
0
votes
1answer
906 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 ...
1
vote
0answers
272 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 ...
4
votes
1answer
857 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 ...
0
votes
1answer
2k 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
0answers
54 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 ...
1
vote
2answers
828 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 ...
2
votes
1answer
1k 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, ...
0
votes
1answer
231 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
1answer
796 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 !
1
vote
0answers
2k 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 ...
1
vote
0answers
1k 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 ...
0
votes
3answers
3k 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.sql content ...