piplinedb 安装配置

piplinedb不能使用root用户操作，提前建好用户

[root@yzh-jkb-privatization /]# useradd steven
[root@yzh-jkb-privatization /]# passwd steven
[root@yzh-jkb-privatization /]# vim /etc/sudoers

root    ALL=(ALL)   ALL
steven  ALL=(ALL)   ALL

 

一、下载rpm包   https://github.com/pipelinedb/pipelinedb/releases

二、安装

[root@yzh-jkb-privatization /]# su - steven
[steven@yzh-jkb-privatization ~]$ mkdir pipelinedb
[steven@yzh-jkb-privatization ~]$ cd pipelinedb/
[steven@yzh-jkb-privatization pipelinedb]$ sudo mv /pipelinedb-0.9.9u1-centos7-x86_64.rpm ./pipelinedb/

 

[steven@yzh-jkb-privatization pipelinedb]$ sudo rpm -ivh pipelinedb-0.9.9u1-centos7-x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:pipelinedb-0.9.9-1               ################################# [100%]
ln: failed to create symbolic link ‘/usr/bin/pipelinedb’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipelinedb-debug’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline-ctl’: File exists
ln: failed to create symbolic link ‘/usr/bin/pg_ctl’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline-init’: File exists
ln: failed to create symbolic link ‘/usr/bin/psql’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline’: File exists
ln: failed to create symbolic link ‘/usr/bin/pg_config’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline-dump’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline-dumpall’: File exists
ln: failed to create symbolic link ‘/usr/bin/pipeline-restore’: File exists

    ____  _            ___            ____  ____
   / __ \(_)___  ___  / (_)___  ___  / __ \/ __ )
  / /_/ / / __ \/ _ \/ / / __ \/ _ \/ / / / __  |
 / ____/ / /_/ /  __/ / / / / /  __/ /_/ / /_/ /
/_/   /_/ .___/\___/_/_/_/ /_/\___/_____/_____/
       /_/

PipelineDB successfully installed. To get started, initialize a
database directory:

pipeline-init -D <data directory>

where <data directory> is a nonexistent directory where you'd
like all of your database files to live.

You can find the PipelineDB documentation at:

http://docs.pipelinedb.com

 

三、初始化目录

1.  在当前目录（piplinedb）下创建文件夹

[steven@yzh-jkb-privatization pipelinedb]$ mkdir testdata
mkdir: cannot create directory ‘testdata’: File exists
[steven@yzh-jkb-privatization pipelinedb]$ mkdir log/testdata -p
[steven@yzh-jkb-privatization pipelinedb]$ pipeline-init -D testdata/

 

 

四、启停命令

1、启动命令  -D 指定数据目录   -l指定log文件

[steven@yzh-jkb-privatization testdata]$ pipeline-ctl -D /home/steven/pipelinedb/testdata/ -l /home/steven/pipelinedb/log/testdata/pipelinedb.log start
server starting

　　

2、停止服务

[steven@yzh-jkb-privatization testdata]$ pipeline-ctl -D /home/steven/pipelinedb/testdata stop 
waiting for server to shut down.... done  
server stopped  

　　

五、修改配置文件同postgresql

 

 

六、连接数据库两种方法

1、第一种

[steven@steven1 testdata]$ pipeline pipeline  
pipeline (9.5.3)  
Type "help" for help. 

　　

 2、第二种

[steven@steven1 testdata]$ psql -p 5432 -h localhost pipeline  
psql (9.6.9, server 9.5.3)  
Type "help" for help.  
  
pipeline=#  

　　

参考：http://blog.sina.com.cn/s/blog_76923bd80102wvl2.html
http://docs.pipelinedb.com/installation.html