postgresql 12.0 源码编译安装
1.安装相关软件包
su - root
yum install -y cmake gcc gcc-c++ perl readline readline-devel openssl openssl-devel zlib zlib-devel ncurses-devel
2.创建用户及相关目录
useradd postgres
passwd postgres
mkdir /pgdata
chown postgres. /pgdata/
3.获取数据库安装包
su - postgres
wget https://ftp.postgresql.org/pub/source/v12.0/postgresql-12.0.tar.gz
#也可以去社区网站下载:https://ftp.postgresql.org/pub/source/v12.0
4.解压、编译安装包
tar -zxvf postgresql-12.0.tar.gz
mkdir pg12
./configure --prefix=/home/postgres/pg12
make
make install
5.配置环境变量
cd /home/postgres
vi .bash_profile
#for postgresql
export PGPORT=5432
export PGHOME=/home/postgres/pg12
export PGDATA=/pgdata
export PATH=$PGHOME/bin:$PATH
export MANPATH=$PGHOME/share/man:$MANPATH
export LANG=UTF-8
export DATE='date &#