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

How to capture remote client hostname in sessions table when using F5 load balancer?

Hello all,

We are using Big IP F5 LTM to load balance traffic across our Vertica nodes. One issue we are facing is that when we use connect to Vertica database through load balancer, the client_hostname in sessions table is stored with IP of the load balancer virtual server, instead of IP of the remote client machine which initiated the session.

What could be the best way to get the remote client IP, instead of load balancer IP?

Thanks,
Rupendra

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.