I need job scheduling and this feature needs pgAgent installed along with postgresql (v15.4) via Stack builder (v4.2.1). But installation process fails with an error:
Things I have tried:
- Run Stack Builder as Administrator
- Reset postgres user password to "admin", "1234" and "12345"
More clues:
Looks like pgAgent is installed, but the directory is not present in C:\Program Files\PostgreSQL or C:\Program Files\PostgreSQL\15
pgAgent service not exists however another similar service is installed!
PS: I already read the other similar question but it didn't help
you'd need to download and install pgAdmin4 to make it easier to install pgAgent on your system, pgAdmin4 comes bundled with pgAgent installed so you don't necessarily have to go through the pain of manually installing that component, checkout https://www.pgadmin.org/download/pgadmin-4-windows/
Or, you could try going into the bin folder of your postgreSQL installation and type,
pgAgent INSTALL pgAgent -u windowsUser-p windowspassword hostaddr=127.0.0.1 dbaname=postgres user=postgres password=***for a manual execution within your installation, although this is a quite hacky approach, I would suggest you to get pgAdmin4 installed rather as it's a MUCH smoother process.