Postgres Pro
Downloads
Home   >   mailing lists

PGBench connection issue with -C option only - Mailing list pgsql-performance

From T T
Subject PGBench connection issue with -C option only
Date
Msg-id CAE4W+S+wuS1=E4mk9dkXGgcOuO71D0Qci-p4c_FdeF+P5OECgw@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
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

--
-
Thanks & Regards,

Tushar K Takate .
Mob-No : +91-860-030-2404
LinkedIn : Tushar Takate
My-Blogs : Tushar Blogspot 

pgsql-performance by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: About Query Performaces Problem
Next
From: arjun shetty
Date:
Subject: Re: PostgreSQLv14 TPC-H performance GCC vs Clang