Скачать или смотреть PostgreSQL Database Server Background Processes

This video talks about PostgreSQL database background server processes that would start/stop with server start/stop.

** Notes**
pg_isready
pg_ctl stop -D /local/apps/postgresql/pgsql115/data/ -m fast
pg_ctl start -D /local/apps/postgresql/pgsql115/data -l /tmp/logfile
pg_isready

ps -f -u postgres --forest
ps -aef --forest

client == Postgres Server Process == It forks new postgres backend process


checkpointer: Normal checkpoint process
background writer: Dirty pages from shared buffers to DIsk
walwriter: redo/transactional buffer to logs on disk
autovacuum launcher: For periodic vaccum process
stats collector: statistics information. pg_stat_activity, pg_stat_database
logical replication launcher: Related replication
******