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、初始化数据库并启动

查看数据库初始化文档

启动数据库

连接数据库