Change a port of the database

kfruchtmankfruchtman Vertica Customer ✭
in General Discussion

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
Keren

Tagged:

Comments

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

  • 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!
    Keren

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...