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!

Connection refused in MAC

I have installed vsql and database in my MAC. but while connecting from vsql m getting following error 
vsql: could not connect to server: Connection refused Is the server running on host "???" and accepting
TCP/IP connections on port 5433?

am executing following command,
vsql  -U dbadmin -w password

and my odbc.ini is like ,

[VMart]Description = Vmart Database
Driver = /Library/ODBC/vertica/lib64/libverticaodbc.dylib
Database = vmartdb
Servername = host01
UID = dbadmin
PWD = password
Port = 5433
Locale = en_GB


  • If you are trying to connect using vsql, then you are not using an ODBC connection.  Try adding the "-h host01" parameter to your vsql command.
  • Hi ,

    After adding host name , am getting following error ,

    vsql: could not translate host name "host01" to address: nodename nor servname provided, or not known

    Please help
  • Navin_CNavin_C Vertica Customer
    Hello Rishi,

    Please check if your database is up and running.

Leave a Comment

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