postgresql 源码安装教程

postgresql 源码安装教程

源码下载

进入官网进行下载源码，并解压源码
https://www.postgresql.org/ftp/source/

编译环境准备

检查安装环境是否安装，以及安装路径的设定 /usr/local/pgsql

./configure --prefix=/usr/local/pgsql

如果有报错，环境缺少条件就安装条件
yum install readline-devel zlib-devel gcc -y

yum install perl-ExtUtils-Embed -y
yum install -y gcc
yum install -y libicu-devel.x86_64
yum install -y readline-devel.x86_64
yum -y install openssl-devel
yum -y install pam-devel.x86_64
yum install -y libxml2-devel.x86_64
yum install -y libxslt.x86_64
yum install -y libxslt-devel.x86_64
yum install -y openldap-devel.x86_64
yum install -y systemd-devel.x86_64
yum install -y tcl-devel.x86_64
yum install -y python-devel.x86_64
(如果没有这个包，就下载yum install -y python36-devel.x86_64)

添加用户 postgres

useradd postgres
passwd postgres
chown -R postgres:postgres /usr/local/pgsql/

修改环境变量
vi ~/.bashrc

添加内容：

PGDATA=/usr/local/pgsql/data
PATH=/usr/local/pgsql/bin:$PATH
export PGDATA PATH

source ~/.bashrc

编译安装

make && make install

初始化数据库，并启动数据

initdb -D /usr/local/pgsql/data/

pg_ctl -D /usr/local/pgsql/data/ -l logfile start

psql 连接查看是否成功

psql -d postgres