This describes the necessary steps to install PgAgent on Ubuntu 14.04.
PgAgent:
- apt-get install pgagent
- -u postgres psql
- CREATE EXTENSION pgagent;
- Check it exists by running select * from pg_extension;
- Edit the .pgpass file and add the connections you will need.
- If you don’t know how to add the .pgpass file see adding pgpass below.
- Execute the following command
- pgagent hostaddre=localhost dbname=postgres user=postgres
- You can also follow https://www.pgadmin.org/docs/1.8/pgagent-install.html as well for installation.
.pgpass:
- touch .pgpass
- Put it in home directory.
- It contains information on connections.
- hostname:port:database:username:password
- Modify permissions for owner read write only
- chmod 600 .pgpass