Hi Community, The below is the link I'm following to install pgagent. My doubt is does pgagent look for an already installed pgadmin? Else can it be installed separately? Link: "https://www.tutorialdba.com/2017/09/how-to-schedule-postgresql-jobs-using.html"; The below is the error I'm facing while trying to run the pgAgent daemon. --While I have given hostaddr as localhost root@pgdbsrv2:~/backups# pgagent hostaddr=localhost dbname=postgres user=postgres root@pgdbsrv2:~/backups# Tue Apr 23 15:28:38 2019 WARNING: Couldn't create the primary connection [Attempt #1] Tue Apr 23 15:28:43 2019 WARNING: Couldn't create the primary connection [Attempt #2] Tue Apr 23 15:28:48 2019 WARNING: Couldn't create the primary connection [Attempt #3] Tue Apr 23 15:28:53 2019 WARNING: Couldn't create the primary connection [Attempt #4] Tue Apr 23 15:28:58 2019 WARNING: Couldn't create the primary connection [Attempt #5] Tue Apr 23 15:29:03 2019 WARNING: Couldn't create the primary connection [Attempt #6] Tue Apr 23 15:29:08 2019 WARNING: Couldn't create the primary connection [Attempt #7] Tue Apr 23 15:29:13 2019 WARNING: Couldn't create the primary connection [Attempt #8] Tue Apr 23 15:29:18 2019 WARNING: Couldn't create the primary connection [Attempt #9] Tue Apr 23 15:29:23 2019 WARNING: Couldn't create the primary connection [Attempt #10] Tue Apr 23 15:29:23 2019 ERROR: Stopping pgAgent: Couldn't establish the primary connection with the database server. --While I given hostaddr as "127.0.0.1" root@pgdbsrv2:~/backups# pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres root@pgdbsrv2:~/backups# Tue Apr 23 15:29:40 2019 ERROR: Unsupported schema version: 3. Version 4 is required - please run pgagent_upgrade.sql. And when I type "which pgagent" it is showing as /usr/bin/pgagent Could you please help me where I'm heading wrong? Looking forward to hear from you. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
