PostgreSQL10.3学习(1)--编译安装
1、概述
操作系统centos7.4,PG10.3
2、环境准备
安装需要的插件
yum install systemtap-sdt-devel.x86_64
yum install gcc
yum install perl-ExtUtils-Embed
yum install readline readline-devel
yum install zlib zlib-devel
yum install openssl openssl-devel
yum install pam pam-devel
yum install libxml2 libxml2-devel
yum install libxslt libxslt-devel
yum install tcl tcl-devel
yum install python python-devel
下载源码包:https://www.postgresql.org/ftp/source/
3、创建用户
useradd pgadmin
3、编译源码
./configure --prefix=/opt/pgadmin/postgresql --with-perl --with-tcl --with-python --with-openssl --with-pam --without-ldap --with-libxml --with-libxslt --enable-thread-safety --with-wal-blocksize=16 --with-blocksize=16 --enable-dtrace --enable-debug
make
make install
4、创建目录并把目录权限赋给pgadmin用户
mkdir /opt/pgadmin
chown -R pgadmin pgadmin/
切换pgadmin用户,创建文件夹
mkdir /opt/pgadmin/pg_data //存放数据库文档
mkdir /opt/pgadmin/pg_install //存放安装文件
将编译好的文件拷贝到pg_install目录中
cp -r /opt/pgadmin/postgresql/* /opt/pgadmin/pg_install/
5、配置环境变量
vi /etc/profile
export PGHOME=/opt/pgadmin/pg_install
export PGDATA=/opt/pgadmin/pg_data
export LD_LIBRARY_PATH=$PGHOME/lib
export PATH=$PGHOME/bin:$PATH:$HOME/bin
source /etc/profile
6、初始化数据库并启动
查看数据库初始化文档
启动数据库
连接数据库