Vertica4x multi-database instance port configuration

Address: http://blog.csdn.net/kongxx/article/details/6530158

I recently used the vertica database and wanted to start multiple database instances at the same time. However, when I started the database, I found that all database instances use the same port: 5433, in this way, only one database instance can be used at a time, which is too restrictive for me to use. So this afternoon, I finally found the vertica port definition file. The above problem can be solved by defining different ports for different database instances. The procedure is 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