Skip to main content

create database on new port

  • April 17, 2013
  • 3 replies
  • 16 views

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

3 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • April 17, 2013
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.

Forum|alt.badge.img+2
  • Participating Frequently
  • April 18, 2013
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.

Siddarth
Forum|alt.badge.img+1
  • Participating Frequently
  • May 1, 2014
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.