PostgreSQL pg_ctl 工具

数据运维 2023-08-15 三掌柜 手机阅读

pg_ctl 是 PostgreSQL数据库自带的实用工具，具有以下功能：

  1. 初始化PostgreSQL数据库实例
  2. 启动，停止，重启PostgreSQL数据库服务
  3. 查看PostgreSQL数据库服务的状态
  4. 让数据库重新读取配置文件
  5. 将备库提升为主库
  6. 给指定的进程发送信号

Usage: pg_ctl init[db] [-D DATADIR] [-s] [-o OPTIONS] pg_ctl start [-D DATADIR] [-l FILENAME] [-W] [-t SECS] [-s] [-o OPTIONS] [-p PATH] [-c] pg_ctl stop [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s] pg_ctl restart [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s] [-o OPTIONS] [-c] pg_ctl reload [-D DATADIR] [-s] pg_ctl status [-D DATADIR] pg_ctl promote [-D DATADIR] [-W] [-t SECS] [-s] pg_ctl kill SIGNALNAME PID