create database on new port

kumaran_Lkumaran_L
in General Discussion
How do I create a database using a port other than default port 5433. admintools create_db command doesn't provide option to specify the port number .

Comments

  • [Deleted User][Deleted User]
    Hi Kumaran, thanks for your question! We'll see if others in the community have set their databse to a port other than the default.
  • [Deleted User][Deleted User]
    One option is create db on default port 5433, stop the db, modify port value in /opt/vertica/config/admintools.conf file manually in each node and restart the db via admintools. See if this helps.
  • SiddarthSiddarth
    Yes we can change the database port to whatever port you want to use even after creating a database. There are some files that needs to configured for it in every node of a cluster.

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