Horton

Add backendType to PGPROC, replacing isRegularBackend

Heikki Linnakangas <heikki.linnakangas@iki.fi>

View on postgr.es
Commit: 084e42bc7109673e46527b0a0f284edf539c3285
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2026-02-04T11:06:04Z
Releases: 19 (unreleased) 
Add backendType to PGPROC, replacing isRegularBackend

We can immediately make use of it in pg_signal_backend(), which
previously fetched the process type from the backend status array with
pgstat_get_backend_type_by_proc_number(). That was correct but felt a
little questionable to me: backend status should be for observability
purposes only, not for permission checks.

Reviewed-by: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://www.postgresql.org/message-id/b77e4962-a64a-43db-81a1-580444b3e8f5@iki.fi

Files

PathChange+/−
src/backend/access/transam/twophase.c modified +1 −1
src/backend/storage/ipc/procarray.c modified +2 −2
src/backend/storage/ipc/signalfuncs.c modified +1 −4
src/backend/storage/lmgr/proc.c modified +2 −2
src/backend/utils/activity/backend_status.c modified +0 −25
src/include/storage/proc.h modified +3 −2
src/include/utils/backend_status.h modified +0 −1

Discussion