安装Vertica数据库 .
下载地址:http://my.vertica.com/
1. 安装Vertica rpm包
2. 创建Vertica用户并设置密码
# useradd dbadmin -d /opt/dbadmin -b /opt/dbadmin
# passwd dbadmin
3. 安装Vertica数据库
# /opt/vertica/sbin/install_vertica -u dbadmin -l /opt/dbadmin -d /opt/dbadmin
4. 管理Vertica数据库。
首先以dbadmin用户登录系统
$ /opt/vertica/bin/admintools
运行admintools
出来一个图形界面
选择配置/创建数据库
[root@redflag11012501 oracle]# rpm -ivh vertica-ce-6.0.1-0.x86_64.RHEL5.rpm
Preparing... ########################################### [100%]
1:vertica-ce ########################################### [100%]
Vertica Analytic Database V6.0.1-0 successfully installed on host redflag11012501
----------------------------------------------------------------------------------
Important Information
----------------------------------------------------------------------------------
If you are upgrading from a previous version, you must backup your database before
continuing with this install. After restarting your database, you will be unable
to revert to a previous version of the software.
----------------------------------------------------------------------------------
To download the latest Vertica documentation in zip or tar format please visit the
myvertica web site.
To complete installation and configuration of the cluster,
run: /opt/vertica/sbin/install_vertica
[root@redflag11012501 oracle]# useradd dbadmin -d /opt/dbadmin -b /opt/dbadmin
[root@redflag11012501 oracle]# passwd dbadmin
Changing password for user dbadmin.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@redflag11012501 oracle]# /opt/vertica/sbin/install_vertica -u dbadmin -l /opt/dbadmin -d /opt/dbadmin
Vertica Analytic Database 6.0.1-0 Installation Tool
Upgrading admintools meta data format..
scanning /opt/vertica/config/users
WARNING: No hostname list provided. Installing to localhost
Starting installation tasks...
Getting system information for cluster (this may take a while)....
backing up admintools.conf on localhost
Checking/fixing OS parameters.....
Setting vm.min_free_kbytes to 4096 ...
Info! The maximum number of open file descriptors is less than 65536
Setting open filehandle limit to 65536 ...
Info! The session setting of pam_limits.so is not set in /etc/pam.d/su
Setting session of pam_limits.so in /etc/pam.d/su ...
Info! Parameter vm.max_map_count is less than 5541326
Setting vm.max_map_count to 5541326 ...
Creating/Checking Vertica DBA group
Creating/Checking Vertica DBA user
Setting /etc/security/limits.conf nproc to 86583 ...
Creating Vertica Data Directory...
Updating spread configuration...
Verifying spread configuration on whole cluster.
Creating node node0001 definition for host localhost
... Done
Error Monitor 0 errors 0 warnings
Installation complete.
To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu
** The installation modified the group privileges for dbadmin.
If you used sudo to install vertica as dbadmin, you will
need to logout and login again before the privileges are applied.
[root@redflag11012501 oracle]# su - dbadmin
[dbadmin@redflag11012501 ~]$ /opt/vertica/bin/adminTools