一、手工方式
(一)、启动
pg_ctl -D /var/postgres/data1 -l logfile start
(二)、关闭
pg_ctl stop [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s]
Shutdown modes are:
- smart quit after all clients have disconnected (要等很久)
- fast quit directly, with proper shutdown (default) (生产推荐使用)
- immediate quit without complete shutdown; will lead to recovery on restart (相当于kill -9)(慎用)
例如:pg_ctl stop -D /var/postgres/data1 -mf (-mf即fast方式)
pg_ctl restart -D /var/postgres/data1 -mf
(三)查看状态
pg_ctl stop status [-D DATADIR]
二、脚本方式
/var/postgre/software-iso/postgresql-14.1/contrib/start-scripts/linux
脚本的如下内容需要修改
脚本是以-s(smart) 方式停止数据库