Thread

  1. PGBench connection issue with -C option only

    T T <tushar11.takate@gmail.com> — 2022-01-13T01:47:49Z

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