[root@localhost ~]# yum groupinstall -y "Development tools"
[root@localhost ~]# yum install -y bison flex readline-devel zlib-devel[root@localhost ~]# wget https://ftp.postgresql.org/pub/source/v11.5/postgresql-11.5.tar.bz2
[root@localhost ~]# tar -xjvf postgresql-11.5.tar.bz2使用用默认配置，安装目录为 /usr/local/pgsql，端口：5432
[root@localhost ~]# cd postgresql-11.5
[root@localhost postgresql-11.5]# ./configure
[root@localhost postgresql-11.5]# gmake world && gmake install编辑 /etc/profile 文件，在末尾加上
export PATH=/usr/local/pgsql/bin:$PATH保存，退出；运行以下名称，使环境变量生效
[root@localhost postgresql-11.5]# source /etc/profile[root@localhost postgresql-11.5]# useradd postgres[root@localhost postgresql-11.5]# mkdir -p /data/pgsql/{data,backups,scripts,archive_wals}
[root@localhost postgresql-11.5]# chown -R postgres:postgres /data/pgsql
[root@localhost postgresql-11.5]# chmod 0700 -R /data/pgsql[root@localhost postgresql-11.5]# su postgres
[postgres@localhost postgresql-11.5]$ initdb -D /data/pgsql/data -W
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
Enter new superuser password:
Enter it again:
fixing permissions on existing directory /data/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg_ctl -D /data/pgsql/data -l logfile start
[postgres@localhost postgresql-11.5]$ exit
exit
[root@localhost postgresql-11.5]# [root@localhost postgresql-11.5]# vi /usr/lib/systemd/system/postgresql.service输入以下内容
[Unit]
Description=PostgreSQL database server
After=network.target
[Service]
Type=forking
User=postgres
Group=postgres
# Port number for server to listen on
Environment=PGPORT=5432
# Location of database directory
Environment=PGDATA=/data/pgsql/data
# Where to send early-startup messages from the server (before the logging
# options of postgresql.conf take effect)
# This is normally controlled by the global default set by systemd
# StandardOutput=syslog
# Disable OOM kill on the postmaster
OOMScoreAdjust=-1000
#ExecStartPre=/usr/local/pgsql/bin/postgresql-check-db-dir ${PGDATA}
ExecStart=/usr/local/pgsql/bin/pg_ctl start -D ${PGDATA} -s -o "-p ${PGPORT}" -w -t 300
ExecStop=/usr/local/pgsql/bin/pg_ctl stop -D ${PGDATA} -s -m fast
ExecReload=/usr/local/pgsql/bin/pg_ctl reload -D ${PGDATA} -s
# Give a reasonable amount of time for the server to start up/shut down
TimeoutSec=300
[Install]
WantedBy=multi-user.target设置权限
[root@localhost postgresql-11.5]# chmod 754 /usr/lib/systemd/system/postgresql.service设置为开机自启动：
[root@localhost postgresql-11.5]# systemctl enable postgresql.service启动服务
[root@localhost postgresql-11.5]# systemctl start postgresql.service停止服务
[root@localhost postgresql-11.5]# systemctl stop postgresql.service重启服务
[root@localhost postgresql-11.5]# systemctl restart postgresql.service
[root@localhost postgresql-11.5]# service postgresql restart使服务自动启动
[root@localhost postgresql-11.5]# systemctl enable postgresql.service使服务不自动启动
[root@localhost postgresql-11.5]# systemctl disable postgresql.service检查服务状态
[root@localhost postgresql-11.5]# systemctl status postgresql.service
[root@localhost postgresql-11.5]# systemctl is-active postgresql.service显示所有已启动的服务
[root@localhost postgresql-11.5]# systemctl list-units --type=service