From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Problem in starting pgagent after installation in ubuntu
Date: Tue, 23 Apr 2019 04:34:17 -0700 (MST)
Message-ID: <1556019257527-0.post@n3.nabble.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: Problem in starting pgagent after installation in ubuntu
In-Reply-To: <1556019257527-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox