技术开发 频道

主流列式数据库评测Ingres VectorWise

 (3)以ingres用户访问(需修改.bash_profile)

   [ingres@redflag11012602 ~]$ vi .bash_profile

  # .bash_profile

  # Get the aliases and functions

  . ~/.bashrc

  fi

  # User specific environment and startup programs

  PATH=$PATH:$HOME/bin

  export PATH

  #.ingVWbash

  # ingresvw environment for VW installation

  # Generated at installation time, any changes made will be lost

  export II_SYSTEM=/user1/app/tmp

  export PATH=$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility:$PATH

  if [ "$LD_LIBRARY_PATH" ] ; then

  LD_LIBRARY_PATH=/usr/local/lib:$II_SYSTEM/ingres/lib:$LD_LIBRARY_PATH

  else

  LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib

  fi

  export LD_LIBRARY_PATH

  export TERM_INGRES=dumb

 

  启动VectorWise服务有2种方式,一种是用ingstart命令,注意不能用root用户执行这个命令,另一种方式是用服务的方式启动,必须以 root用户执行/sbin/serviceingresVW start命令。只有rpm安装的软件才支持第2种方式。

       [root@redflag11012602 ingres]# ingstart

  
Starting Ingres as root is not permitted.

  [root@redflag11012602 ingres]# su - ingres

  [ingres@redflag11012602 ~]$ ingstart

  -bash: ingstart: command not found

  [ingres@redflag11012602 ~]$ . /home/ingres/.ingVWbash

  [ingres@redflag11012602 ~]$ ingstart

  VectorWise/ingstart

  No VectorWise servers have been configured to start up.

  [ingres@redflag11012602 ~]$ /sbin/service ingresVW start

  Only 'root' can control this service

  [ingres@redflag11012602 ~]$ exit

  logout

  [root@redflag11012602 ingres]# /sbin/service ingresVW start

  Ingres, instance VW has not been setup

  Running setup for Ingres 1.5.0-141...

  Running setup for dbms... OK

  Running setup for net... OK

  Running iisudbms... OK

  Running iisudas... OK

  Running iisuodbc... OK

  Starting Ingres, instance VW: [确定]

0