PostgreSQL DBA

Architecture & Internals for Administrators

Question

Postmaster versus backend process: what differs operationally?

Answer

The postmaster listens for connections, forks one backend per session, and supervises all server processes. A backend runs one session's queries. An ERROR or FATAL ends only that backend's work or session. A backend crash makes the postmaster terminate all sessions, then normally run crash recovery.

This is 1 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples