Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to install and use pgAgent for postgres

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?

like image 242
Stathis Andronikos Avatar asked Sep 17 '25 21:09

Stathis Andronikos


1 Answers

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

like image 175
Murtuza Z Avatar answered Sep 21 '25 06:09

Murtuza Z