This article address: http://blog.csdn.net/kongxx/article/details/6656658
Today upgraded Vertica from 4.0.x to 5.0.4 version, found vertica4x multiple database instance port configuration The method mentioned in the article is no longer applicable, do some research findings can be achieved through the following steps:
1. First stop all the database instances;
2. Create multiple database instances, such as MYDB1 and MYDB2;
3. Edit the/opt/vertica/config/admintools.conf file and change the ports in the MYDB1 and MYDB2 configuration sections to their desired ports as follows:
[Configuration]
install_opts = ['-U ', ' Fkong ']
default_base =/home/dbadmin
show_hostnames = False
format = 3
[Cluster]
hosts = 127.0.0.1
spread_hosts =
[Nodes]
node0001 = 127.0.0.1,/opt/dbadmin,/opt/dbadmin
v_ mydb1_node0001 = 127.0.0.1,/opt/vertica/db/mydb1,/opt/vertica/db/mydb1
v_mydb2_node0001 = 127.0.0.1,/opt/ VERTICA/DB/MYDB2,/OPT/VERTICA/DB/MYDB2
[DATABASE:MYDB1]
host = 127.0.0.1
Restartpolicy = Ksafe
port = 5551
Path =/opt/vertica/db/mydb1
nodes = v_mydb1_node0001
[DATABASE:MYDB2]
host = 127.0.0.1
restartpolicy = ksafe
port = 5552
Path =/OPT/VERTICA/DB/MYDB2 nodes
= v_mydb2_node0001
4. Restart the vertica5x service.