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
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.
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.