How to install and use pgAgent for postgres

postgresql pgadmin-4 pgagent
Stathis Andronikos picture Stathis Andronikos · Sep 22, 2017 · Viewed 9k times · Source

I have downloaded separately pgagent 3.4.1 & pgAdmin 4. I want to create jobs from inside pgAdmin like explained https://www.openscg.com/bigsql/docs/pgadmin4/pgagent_install.html but when I execute the command I get the error : ERROR: could not open extension control file "E:/Program Files (x86)/PostgreSQL/9.6/share/extension/pgagent.control": No such file or directory SQL state: 58P01. Is there any link that gives details how to install & use pgAgent from inside pgAdmin 4?

Answer

Murtuza Z picture Murtuza Z · Sep 25, 2017

It is very easy if you will use the EnterpriseDB GUI installers.

1) Download & Install PostgreSQL-9.6(standard) from installers provided by EnterpriseDB

Download link

2) Open Stack builder from Menu -> Choose the Postgres server you want to install pgAgent on from the list

enter image description here

enter image description here

3) Now select pgAgent and click Next to install and follow the steps.

enter image description here

4) Restart pgAdmin4 and you will be able to see the pgAgent option in the browser window tree.

(I am using pgAdmin4 rc build so ICONS may looks different)

enter image description here

Related questions

pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_…

Read More
FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any …

Read More
pgAdmin won't start (eternal loading)

Once upon a time I had a Postgres database that worked with pgAdmin. I have a webservice running on a WildFly server that made connections to the DB and everything worked fine. After a while(a few months) I have …

Read More