1、安装相关的依赖包
配置相关的yum源,并安装想管依赖包,如下:
yum -y install readline* zlib*
2、解压二进制安装到指定目录
3、执行安装
./configure
make
su
make install
adduser postgres
4、创建数据目录并授权
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
5、初始化数据库
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
6、启动数据库
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile
7、创建数据库
/usr/local/pgsql/bin/createdb test
8、登录数据库
/usr/local/pgsql/bin/psql test
9、将数据库启动加入到system里面
新增文件:/etc/systemd/system/postgresql.service
内容如下:
[Unit]
Description=PostgreSQL database server
Documentation=man:postgres(1)
After=network-online.target
Wants=network-online.target
[Service]
Type=notify
User=postgres
ExecStart=/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=infinity
[Install]
WantedBy=multi-user.target
10、启停数据库方法
systemctl start/stop/restart postgresql.service
或者
pg_ctl start -D /usr/local/pgsql/data -l logfile
pg_ctl stop -D /usr/local/pgsql/data




