单实例安装

一、安装环境准备

安装必要的依赖包 CentOS:

yum install -y wget gcc readline-devel zlib-devel

Ubuntu

apt install -y gcc make zlib1g-dev libreadline-dev

二、下载源码包

mkdir -p /opt/package && cd /opt/package
wget https://ftp.postgresql.org/pub/source/v12.13/postgresql-12.13.tar.gz --no-check-certificate

三、编译安装

# 解压安装包
cd /opt/package && tar xf postgresql-12.13.tar.gz
# 创建编译目录
cd postgresql-12.13 && mkdir build_dir && cd build_dir
# 创建安装目录
mkdir -p /opt/software/postgresql/12.13
# configure
../configure --prefix=/opt/software/postgresql/12.13
# 编译pg和contrib
make world-bin
# 安装pg和contrib
make install-world-bin
# 创建postgres用户，用来启动数据库
adduser postgres
# 创建data目录
mkdir -p /opt/software/postgresql/data
chown postgres:postgres /opt/software/postgresql/data

四、配置环境变量

切换到postgres用户配置相关环境变量

cat >> .bashrc << "EOF"
export PGHOME=/opt/software/postgresql/12.13
export PATH=$PGHOME/bin:$PATH
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib
export PGDATA=/opt/software/postgresql/data
EOF
source .bashrc

五、初始化数据库

initdb

六、启动数据库

pg_ctl start -l logfile

七、停止数据库

pg_ctl stop