Hi Team ,
We are getting below error while running pgbench -
could not connect to server: Cannot assign requested address
Is the server running on host "tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com" (100.10.11.4) and accepting
TCP/IP connections on port 5432?
client 75 aborted while establishing connection
connection to database "pgbenchtest" failed:
could not connect to server: Cannot assign requested address
Is the server running on host "i"tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com" (100.10.11.4) and accepting
TCP/IP connections on port 5432?
client 38 aborted while establishing connection
connection to database "pgbenchtest" failed:
could not connect to server: Cannot assign requested address
Is the server running on host "tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com" (100.10.11.4) and accepting
TCP/IP connections on port 5432?
client 75 aborted while establishing connection
connection to database "pgbenchtest" failed:
could not connect to server: Cannot assign requested address
Is the server running on host "i"tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com" (100.10.11.4) and accepting
TCP/IP connections on port 5432?
client 38 aborted while establishing connection
connection to database "pgbenchtest" failed:
could not connect to server: Cannot assign requested address
Pgbench command -
/usr/pgsql-11/bin/pgbench -U postgres -h tushartest-ist-pgec2-a7-prod-lb-4637832643276542.elb.us-east-1.amazonaws.com -p 5432 -c 100 -C -j 5 -T 21600 pgbenchtest -s 10 -r -P 5 -f /var/lib/pgsql/pgbench/test_insert.sql
Can you please help us with the expected cause and solution .
Note : we are seeing this error when we are using the " -C " option only .
-
Thanks & Regards,
Tushar K Takate .Thanks & Regards,
LinkedIn : Tushar Takate