一、下载安装包
官方下载地址:https://www.postgresql.org 点击 “Download” ——“Source”——“v11.5”(选择合适的版本)——“postgresql-11.5.tar.gz”或“postgresql-11.5.tar.bz2”
二、编译安装
将下载的安装包 “postgresql-11.5.tar.bz2” 上传到Linux服务器。 解压安装包
$ tar xjvf postgresql-11.5.tar.bz2
编译安装
$ cd postgresql-11.5
// --prefix用于指定安装目录
$ ./configure --with-systemd --prefix= $HOME /opt/postgresql1.5
$ make
$ make install
$ make -C src/bin install
$ make -C src/include install
$ make -C src/interfaces install
$ make -C doc install
设置环境变量
$ vi $HOME /.bash_profile
PATH= $PATH : $HOME /opt/postgresql1.5/bin
LD_LIBRARY_PATH= $HOME /opt/postgresql1.5/lib
export PATH
export LD_LIBRARY_PATH
$ source $HOME /.bash_profile
创建数据目录
$ mkdir $HOME /data
$ chown -R appadmin:appadmin $HOME /data
初始化数据库
$ initdb -D $HOME /data
三、启动与停止
启动
$ mkdir $HOME /logs
$ pg_ctl -D $HOME /data -l $HOME /logs/pg.log start
$ postgres -D $HOME /data > $HOME /logs/pg.log 2> & 1 &
查看数据库状态
$ pg_ctl -D $HOME /data -l $HOME /logs/pg.log status
pg_ctl: server is running ( PID: 28985)
/home/appadmin/opt/PostgreSQL11.5/bin/postgres "-D" "/home/appadmin/data"
测试数据库是否安装成功
$ createdb test
$ psql test
test=
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | appadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | appadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | = c/appadmin +
| | | | | appadmin= CTc/appadmin
template1 | appadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | = c/appadmin +
| | | | | appadmin= CTc/appadmin
test | appadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
( 4 rows)
test=
停止
$ pg_ctl -D $HOME /data -l $HOME /logs/pg.log stop
四、开机启动
vi /etc/systemd/system/postgresql.service
[ Unit]
Description= PostgreSQL database server
Documentation= man:postgres( 1)
[ Service]
Type= notify
User= postgres
ExecStart= $HOME /opt/postgresql1.t/bin/postgres -D $HOME /data
ExecReload= /bin/kill -HUP $MAINPID
KillMode= mixed
KillSignal= SIGINT
TimeoutSec= 0
[ Install]
WantedBy= multi-user.target