Change a port of the database

kfruchtmankfruchtman Vertica Customer

Hi Vertica experts!
I have been creating another db on the same machine as the old db.I need to change the port of it inorder for both of them to work together (since both of them are on 5433 they cannot work simultaneously (I know it is not recommended it is just for testing purposes not for production).I cannot find in the documentation where to change the port other than /opt/vertica/config/admintools.conf file. Are there other places I should change the port or just this file is enough?
Many thanks


  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee

    @kfruchtman port 5433 is used for Vertica spread monitoring and Vertica client communication. It's not advisable to change the port. If you want to create a new db on the same machine you need to stop the the old DB first.

  • Options
    kfruchtmankfruchtman Vertica Customer

    Hi !
    I am stopping the old db always before since I cannot use this port twice for 2 db's.
    The issue has been solved.I removed and imported the db's again.I don't know what was the problem but it is ok now.
    Many thanks for your help!

Leave a Comment

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