Pgagent not working

From: avinash varma <avinashvarma443(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Pgagent not working
Date: 2020-07-29 11:39:51
Message-ID: CADaHE9EhenFC+oOSQLYgm0xiTbZYWUVbXmx4fOM9HYid=HGYmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

Pgagent is trying to establish a connection using a wrong IP address. Can
Someone please point me where i can update the host details.

[postgres(at)202susedboncentos8 ~]$ pgagent_12 -f -l 2 hostaddr=127.0.0.1
dbname=OTMM user=towner
Wed Jul 29 17:00:18 2020 DEBUG: Creating primary connection
Wed Jul 29 17:00:18 2020 DEBUG: Parsing connection information...
Wed Jul 29 17:00:18 2020 DEBUG: user: towner
Wed Jul 29 17:00:18 2020 DEBUG: dbname: OTMM
Wed Jul 29 17:00:18 2020 DEBUG: hostaddr: 127.0.0.1
Wed Jul 29 17:00:18 2020 DEBUG: Creating DB connection: user=towner
hostaddr=127.0.0.1 dbname=OTMM
Wed Jul 29 17:00:18 2020 DEBUG: Database sanity check
Wed Jul 29 17:00:18 2020 DEBUG: Clearing zombies
Wed Jul 29 17:00:18 2020 DEBUG: Checking for jobs to run
Wed Jul 29 17:00:18 2020 DEBUG: Creating job thread for job 1
Wed Jul 29 17:00:18 2020 DEBUG: Destroying job thread for job 1
Wed Jul 29 17:00:18 2020 DEBUG: Destroying job thread for job 1
Wed Jul 29 17:00:18 2020 DEBUG: Sleeping...
Wed Jul 29 17:00:18 2020 DEBUG: Creating DB connection: user=towner
hostaddr=127.0.0.1 dbname=OTMM
Wed Jul 29 17:00:18 2020 DEBUG: Parsing connection information...
Wed Jul 29 17:00:18 2020 DEBUG: Allocating new connection for the database
with connection string: user=towner dbname=OTMM hostaddr=127.0.0.1...
Wed Jul 29 17:00:18 2020 DEBUG: Starting job: 1
Wed Jul 29 17:00:18 2020 DEBUG: Parsing connection information...
Wed Jul 29 17:00:18 2020 DEBUG: user: towner
Wed Jul 29 17:00:18 2020 DEBUG: password: *****
Wed Jul 29 17:00:18 2020 DEBUG: dbname: OTMM

*Wed Jul 29 17:00:18 2020 DEBUG: host: 10.96.153.182 -- This is not the
correct IP*Wed Jul 29 17:00:18 2020 DEBUG: port: 5432
Wed Jul 29 17:00:18 2020 DEBUG: Creating DB connection: user=towner
password=towner host=10.96.153.182 port=5432 dbname=OTMM
Wed Jul 29 17:00:21 2020 WARNING: Failed to create new connection for
connection string 'host=10.96.153.182 port=5432 dbname=OTMM user=towner
password=towner': could not connect to server: No route to host
Is the server running on host "10.96.153.182" and accepting
TCP/IP connections on port 5432?
Wed Jul 29 17:00:21 2020 DEBUG: Parsing connection information...
Wed Jul 29 17:00:21 2020 DEBUG: Returning the connection to the connection
pool: 'user=towner dbname=OTMM hostaddr=127.0.0.1'...
Wed Jul 29 17:00:21 2020 DEBUG: Completed job: 1
Wed Jul 29 17:00:21 2020 DEBUG: Destroying job thread for job 1
^C
[postgres(at)202susedboncentos8 ~]$

--
Thanks & Regards,

Avinash.

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2020-07-29 20:41:59 Re-order columns?
Previous Message ZongtianHou 2020-07-29 09:42:17 Re: how to conveniently upgrade with specific catalog change