Vertica could not translate host name "xxxx" to address

edited August 2019 in General Discussion

Hello All,
When trying to connect to vertica database (Vertica Analytic Database v8.0.1-4), i get the below error. However it works some times.
SQL State: 08001
Native Error: 160
Error Message: [Vertica][VerticaDSII] (160) connection attempt failed:could not
translate host name "xxxxxxx.com" to address: This is usually
a temporary error during hostname resolution and means that the local server did
not receive a response from an authoritative server.

However when i tried to connect from a different machine, it works with out any error.
Appreciate your help.


  • Options
    SruthiASruthiA Vertica Employee Administrator

    Are you using DNS Server to resolve hostnames? If so check DNS Server logs to see if the name resolution to IP address is failing. In order to over come this error, you can use IP address instead of hostname while connecting or add an entry vertica server IP address to /etc/hosts file on the machine from where you are trying to connect to Vertica.

Leave a Comment

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