Tag: pgpass

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