postgres$ ps -o pid,command --ppid `head -n 1 $PGDATA/postmaster.pid`
PID COMMAND 10530 postgres: checkpointer process 10531 postgres: writer process 10532 postgres: wal writer process 10533 postgres: autovacuum launcher process 10534 postgres: stats collector process 10535 postgres: bgworker: logical replication launcher
К процессам, обслуживающим буферный кэш и журнал, можно отнести:
postgres$ rm /home/postgres/logfile
postgres$ pg_ctl -w -l /home/postgres/logfile -D /usr/local/pgsql/data restart
waiting for server to shut down.... done server stopped waiting for server to start.... done server started
Журнал сообщений сервера:
postgres$ cat /home/postgres/logfile
2018-03-02 14:25:48.027 MSK [11067] LOG: listening on IPv4 address "0.0.0.0", port 5432 2018-03-02 14:25:48.027 MSK [11067] LOG: listening on IPv6 address "::", port 5432 2018-03-02 14:25:48.030 MSK [11067] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2018-03-02 14:25:48.044 MSK [11068] LOG: database system was shut down at 2018-03-02 14:25:47 MSK 2018-03-02 14:25:48.046 MSK [11067] LOG: database system is ready to accept connections
postgres$ rm /home/postgres/logfile
postgres$ pg_ctl -w -l /home/postgres/logfile -D /usr/local/pgsql/data restart -m immediate
waiting for server to shut down.... done server stopped waiting for server to start.... done server started
Журнал сообщений сервера:
postgres$ cat /home/postgres/logfile
2018-03-02 14:25:48.314 MSK [11113] LOG: listening on IPv4 address "0.0.0.0", port 5432 2018-03-02 14:25:48.314 MSK [11113] LOG: listening on IPv6 address "::", port 5432 2018-03-02 14:25:48.317 MSK [11113] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2018-03-02 14:25:48.331 MSK [11114] LOG: database system was interrupted; last known up at 2018-03-02 14:25:48 MSK 2018-03-02 14:25:48.573 MSK [11114] LOG: database system was not properly shut down; automatic recovery in progress 2018-03-02 14:25:48.575 MSK [11114] LOG: invalid record length at 0/17AD8BC: wanted 24, got 0 2018-03-02 14:25:48.575 MSK [11114] LOG: redo is not required 2018-03-02 14:25:48.583 MSK [11113] LOG: database system is ready to accept connections
Перед тем, как начать принимать соединения, СУБД выполнила восстановление (automatic recovery in progress).