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


  • Options
    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.
  • Options
    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
  • Options
    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