SK21SK21 Vertica Customer

Hello I am using connect utility so that i can transfer some data to test database but it is returning this error.
Checked with the network team and it looks fine from their side.
Can someone help here?
dbadmin=> CONNECT TO VERTICA vdb USER dbadmin PASSWORD 'vertica' ON '',5433;
ERROR 2823: Could not connect to server []: Operation now in progress
Is the server running and accepting
TCP/IP connections on port 5433?


  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    What happens if you run:

    \! /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h

    Are the database in different subnets?

  • SK21SK21 Vertica Customer
    edited May 2021

    Hello @Jim_Knicely
    Same trying to execute this on production(inet addr: Bcast: Mask:
    to connect POC DB( inet netmask broadcast
    [dbadmin@verticadb-1 ~]$ /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h
    vsql: could not connect to server: Connection timed out
    Is the server running on host "" and accepting
    TCP/IP connections on port 5433?
    You have mail in /var/spool/mail/dbadmin

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited May 2021

    Can you ping or ssh into it? If you can ssh into it, check if Vertica is running :)

    Also, is there a public IP address for the POC node? Maybe you can connect to it?

    /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<public ip-addres >>

    If you can connect, you will have to change the export addresses on the nodes in prod (if possible).

    See: Changing Node Export Address

    Or, you can copy data using vsql. Say you want to copy data from table JIM in Prod to table JIM in POC:

    /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<prod DB >> -c "SELECT * FROM jim;" | /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <<POC DB >> -c "COPY jim FROM STDIN;" 

    Unfortunately with a lot of data that might be kind of slow. But you can run alot of those COPY commands in parrallel.

  • SK21SK21 Vertica Customer

    Hello @Jim_Knicely vertica is running in both clusters, ping is fine although ssh is not setup,can this be a possible problem?
    Also are you sure about this command
    /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <> -c "SELECT * FROM jim;" | /opt/vertica/bin/vsql -d vdb -U dbadmin -w vertica -h <> -c "COPY jim FROM STDIN;"
    I mean the starting of it vsql -d vdb? from prod server?

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    No, you don't need SSH to be working. But if the database are different subnets, you have to change the EXPORT node addresses.

    See: Configuring Network to Import and Export Data

    For that command I sent, it first selects data from prod and then passes (i.e. pipes) the output to the second vsql commadn which loads it from standard in.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file