在centos安装postgresql
1、下载安装包并解压
下载地址:https://www.postgresql.org/download/
执行:
./configure --prefix=/home/program/pgsql9.6.2 --with-perl --with-python
安装过程中可以会有报错,以下是我在安装时报的一些信息,可以参考:
若报错:configure: error: could not determine flags for linking embedded Perl.
yum install perl-ExtUtils-Embed
若报错:configure: error: readline library not found
yum install readline-devel
若报错:configure: error: header file
configure: error: header file
yum install python-devel
若报错:configure: error: zlib library not found
yum install zlib-devel
2、增加pg运行帐户
如:postgresql,再给 安装目录 和 PGDATA 目录设置此帐户的权限:
useradd pguser -s /bin/bash -d /home/pguser
passwd pguser(设置密码)
mkdir /home/pguser/pgdata
chown postgresql:postgresql /home/pgdata/ -R
3、设置环境变量:
vi /etc/profile.d/env_pgsql.sh
PGSQL=/home/pguser/pgsql9.6.2
export PGDATA=/home/pguser/pgdata
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGSQL/lib
export PATH=$PATH:$PGSQL/bin
5、测试运行
su postgresql
初始化:
initdb
启动:
pg_ctl stop -D $PGDATA
关闭:
pg_ctl start-D $PGDATA
postgresql,pgsql | 2018-02-18 02:17:17