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/>
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 |