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@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@202susedboncentos8 ~]$
--
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@202susedboncentos8 ~]$
Thanks & Regards,
Avinash.