select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pg_readonly

cluster database read only

pgext.cloud · Source code · Control file · PGXN

Overview

Packagepg_readonly
Version1.0.6
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_readonly
Stars19
Latest commit2026-07-15
Latest release2026-07-15
Catalogue updated2026-08-30

Related extensions

See also

plan_filterfilter statements by their execution plans.
pg_kpartReject full partition scans that omit the partition key
prioritizeget and set the priority of PostgreSQL backends
qosQoS resource governor extension for PostgreSQL sessions and queries
pg_permissionsview object permissions and compare them with the desired state
set_usersimilar to SET ROLE but with added logging
pg_roastOpinionated PostgreSQL database auditor
pg_command_fwDDL and utility command firewall for PostgreSQL
pg_hint_planGive PostgreSQL ability to manually force some decisions in execution plans.