The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!


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