PGBench connection issue with -C option only

From: T T <tushar11(dot)takate(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: PGBench connection issue with -C option only
Date: 2022-01-13 01:47:49
Message-ID: CAE4W+S+wuS1=E4mk9dkXGgcOuO71D0Qci-p4c_FdeF+P5OECgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

*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 .
Mob-No : +91-860-030-2404
LinkedIn : Tushar Takate <https://in.linkedin.com/in/tushar-takate-93660867>

--
-
Thanks & Regards,

Tushar K Takate .
Mob-No : +91-860-030-2404
LinkedIn : Tushar Takate <https://in.linkedin.com/in/tushar-takate-93660867>
My-Blogs : Tushar Blogspot <http://tushar-postgresql.blogspot.in/>

Browse pgsql-performance by date

  From Date Subject
Next Message arjun shetty 2022-01-18 14:22:18 Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Previous Message Julien Rouhaud 2022-01-12 08:35:23 Re: About Query Performaces Problem