The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica could not translate host name "xxxx" to address

ditheshdithesh
edited August 9 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.

Comments

  • SruthiASruthiA Employee Employee

    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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.