A user-defined process which runs as part of the main postgres server process
background worker (commonly abbreviated to
BGW) is a user-defined process which runs as part of the main postgres server process
Background worker functionality was added in PostgreSQL 9.3.
- PostgreSQL 11
bgw_typefield added; the value set here will be visible in
backend_typecolumn instead of the generic value "
background worker", and also shown as the
psprocess display label (commit 5373bc2a)
- background workers can attach to databases which normally disallow connections (
false) (commit eed1ce72)
- PostgreSQL 10
- PostgreSQL 9.4
- PostgreSQL 9.3
- initial support added (commit da07a1e8)