cancel
Showing results for 
Search instead for 
Did you mean: 

installing pgAgent via Stack Builder.

LIT
Level 3 Traveller

installing pgAgent via Stack Builder.

Hi,

 

I want to create scheduled jobs in PostgreSQL database server.

Therefore I want to install pgAgent and for this I want to use Stack Builder.

 

When running Stack Builder, I don't get the option to select pgAgent.  

pgAgent is not listed in any of the categories.

 

Please advice where to find an installer for pgAgent on Windows 64bit.

 

Current toolchain :

- operational PostgreSQL database server V9.5.20-2 Windows 64bit

- Windows Server 2012 Standard

- pgAdmin 4 V4.16

- Stack Builder 4.2.0

 

Thank you.

 

 

1 REPLY 1
Highlighted
EDB Team Member

Re: installing pgAgent via Stack Builder.

Hi

The pgAgent is available with pgAdmin and not as separate module.
So you won't find that listed in the Stack Builder.

You can have the installation details for pgAgent at the below link.

https://www.enterprisedb.com/edb-docs/d/pgadmin-4/reference/online-documentation/4.16/pgagent.html

Other option is through command-line like below

pgAgent INSTALL pgAgent u- UserAccount -p password hostaddr=127.0.0.1 dbname=postgres user=postgres

Since, this is a agent through which we can schedule jobs and queries, this sould be initiated as a service.