Last active
June 12, 2020 16:14
-
-
Save kdk2933/741e4f5ea5ca18f386054ed57f8cd859 to your computer and use it in GitHub Desktop.
How to install PGagent from sourcecode
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://www.mkyong.com/database/how-to-install-pgagent-on-windows-postgresql-job-scheduler/ | |
| download the sourcecode and look for postgres.sql file and go to pgadmin and postgres datebase and run the postgres.sql file on postgres datebase and then restart the pgadmin and check for pgagentjob tab available. | |
| This pgagent is only to schedule jobs on pgagent for databases. | |
| Proper steps: | |
| 1. FIrst download the source code from here as the appliation is not avalable from stack builder | |
| https://www.pgadmin.org/download/pgagent-windows/ | |
| 2. Extract it and then place the pgagent_sourcecode folder in pgadmin folder for example: C:\Program Files\PostgreSQL\9.6\pgAdmin 4\pgAgent-4.0.0-Source\ | |
| and go to pgagent.sql file from here "C:\Program Files\PostgreSQL\9.6\pgAdmin 4\pgAgent-4.0.0-Source\" and copy the code and run it or from tabs select Object and click CREATE Script and then paste the script and then run it from there. | |
| and restart the pgadmin then it appers |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment