vertica4x multiple database instance port configuration

This article address: http://blog.csdn.net/kongxx/article/details/6530158

Recently in the Vertica database, you want to start multiple database instances at the same time, but when you start to find all database instances are using the same port: 5433, so that at the same time can only use a database instance, which for me to use too much restrictions. So this afternoon, I finally found that the Vertica port definition file, for different database instances to define different ports can solve the above problem. The steps are as follows:

1. Create Multipul Database instances through "AdminTools". for EXAMPLE:MYDB1 and MYDB2;

2. Shutdown all database instances through "admintools";

3. Change port number for database instances.

Backup ${vertica_top}/config/share/portinfo.dat file, and change port number for some database instances.

For EXAMPLE:MYDB1 uses 5433, MYDB2 uses 5444.

4. Restart Verticad Service

$ SUDO/ETC/INIT.D/VERTICAD Restart