源码安装PostgreSQL

获取介质

https://ftp.postgresql.org/pub/source/v14.4/postgresql-14.4.tar.gz

安装过程简述

./configure --prefix=/postgre/postgreSQL
make
su
make install
adduser postgres
mkdir /postgre/data
chown postgres /postgre/data
su - postgres
/postgre/postgreSQL/bin/initdb -D /postgre/data
/postgre/postgreSQL/bin/pg_ctl -D /postgre/data -l logfile start
/postgre/postgreSQL/bin/createdb test
/postgre/postgreSQL/bin/psql test
复制

如果make时想保留源文件，可以创建一个临时目录进行编译

任意地方创建build_dir目录，我习惯在软件解压目录中创建
mkdir build_dir
cd build_dir
/soft/postgresql-14.4/configure --prefix=/postgre/postgreSQL
make
make install
复制

编译时报错：

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -I. -I/soft/postgresql-12.11/src/test/isolation -I/soft/postgresql-12.11/src/interfaces/libpq -I/soft/postgresql-12.11/src/test/isolation/../regress -I../../../src/include -I/soft/postgresql-12.11/src/include  -D_GNU_SOURCE   -c -o specparse.o /soft/postgresql-12.11/src/test/isolation/specparse.c
gcc: error: ./specs: Is a directory
make[2]: *** [specparse.o] Error 1
make[2]: Leaving directory `/soft/postgresql-12.11/build/src/test/isolation'
make[1]: *** [all-test/isolation-recurse] Error 2
make[1]: Leaving directory `/soft/postgresql-12.11/build/src'
make: *** [all-src-recurse] Error 2
复制

• 是因为root用户编译安装时设置了环境变量导致：

注释修复
unset LD_LIBRARY_PATH
unset LIBRARY_PATH
复制

安装完成后配置环境变量

export PATH=$PATH:/postgre/postgreSQL/bin
export LD_LIBRARY_PATH=$PATH:/postgre/postgreSQL/lib
export MANPATH=$MANPATH:/postgre/postgreSQL/share/man
export PGHOME=/postgre/postgreSQL
export PGDATA=/postgre/data
复制