Menu
I'm trying to install pgagent in a windows environment. Postgresql version 9.6 is installed and application stack builder was installed with it. I have followed the steps, detailed here.
The first step in this guide is to create the extension in the maintenance db, and I am not able to do that.
"ERROR: could not open extension control file "C:/Program Files/PostgreSQL/9.6/share/extension/pgagent.control": No such file or directory SQL state: 58P01"
Tryied to skip this step and go straight to the installation with application stack builder, but the pgAgent tool does not show up.
I also tried to install it as a service using the command line instead of stack builder.
pgAent.exe INSTALL pgAgent -u postgres -p secret hostaddr=127.0.0.1 dbname=postgres user=postgres
This worked to some degree. The only error I get is this.
"Windows could not start pgAgent service on the local computer. Error 1069: The service did not start due to a logon failure."
But I have tried all possible combinations of usernames, passwords, secrets, ports and so on....
Any help would be much appreciated.
544
You can invoke Stack Builder at any time after the installation has completed by selecting the Application Stack Builder menu option from the PostgreSQL 13 menu. Enter your system password (if prompted), and the Stack Builder welcome window opens.
Stack builder is defined as a utility which provides a graphical interface in order to simplify the downloding and installing process of modules which are used to complements the installation process of PostgreSQL. Stack builder helps in resolving software dependencies while you download any module using Stack builder.
To verify the pgAgent service is running, open Control Panel, Administrative Tools, and then Services. The pgAgent service should be one of the started services. If the pgAgent service is not running, click the Start link.
I had the same problem. I was able to get pgagent working by downloading and executing the stand-alone installation file pgagent-3.4.0-4-windows.exe from here: http://sbp.enterprisedb.com/getfile.jsp?fileid=11842
165
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
