Extensions
pg_readonly

pg_readonly

pg_readonly : cluster database read only

Overview

ID Extension Package Version Category License Language
5120
pg_readonly
pg_readonly
 1.0.3
ADMIN
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
pg_permissions
pg_upless
safeupdate
set_user
pgaudit
noset
sepgsql
login_hook

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.0.3
18
17
16
15
14
13
 pg_readonly -
RPM
PGDG
 1.0.3
18
17
16
15
14
13
 pg_readonly_$v* -
DEB
PGDG
 1.0.3
18
17
16
15
14
13
 postgresql-$v-pg-readonly -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
el8.aarch64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
el9.x86_64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
el9.aarch64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
el10.x86_64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
el10.aarch64
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
PGDG 1.0.3
d12.x86_64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
d12.aarch64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
d13.x86_64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
d13.aarch64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
u22.x86_64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
u22.aarch64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
u24.x86_64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
u24.aarch64
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
PIGSTY 1.0.3
Package Version OS ORG SIZE File URL
pg_readonly_18 1.0.3 el8.x86_64 pgdg 16.6 KiB pg_readonly_18-1.0.3-5PGDG.rhel8.x86_64.rpm
pg_readonly_18 1.0.3 el8.aarch64 pgdg 16.5 KiB pg_readonly_18-1.0.3-5PGDG.rhel8.aarch64.rpm
pg_readonly_18 1.0.3 el9.x86_64 pgdg 16.5 KiB pg_readonly_18-1.0.3-5PGDG.rhel9.x86_64.rpm
pg_readonly_18 1.0.3 el9.aarch64 pgdg 16.0 KiB pg_readonly_18-1.0.3-5PGDG.rhel9.aarch64.rpm
pg_readonly_18 1.0.3 el10.x86_64 pgdg 16.8 KiB pg_readonly_18-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_18 1.0.3 el10.aarch64 pgdg 16.7 KiB pg_readonly_18-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-18-pg-readonly 1.0.3 d12.x86_64 pigsty 19.4 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-readonly 1.0.3 d12.aarch64 pigsty 19.1 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-readonly 1.0.3 d13.x86_64 pigsty 19.3 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-readonly 1.0.3 d13.aarch64 pigsty 19.2 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-readonly 1.0.3 u22.x86_64 pigsty 19.9 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-readonly 1.0.3 u22.aarch64 pigsty 19.7 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-readonly 1.0.3 u24.x86_64 pigsty 20.0 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-18-pg-readonly 1.0.3 u24.aarch64 pigsty 19.8 KiB postgresql-18-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_readonly_17 1.0.3 el8.x86_64 pgdg 16.6 KiB pg_readonly_17-1.0.3-4PGDG.rhel8.x86_64.rpm
pg_readonly_17 1.0.3 el8.aarch64 pgdg 16.4 KiB pg_readonly_17-1.0.3-4PGDG.rhel8.aarch64.rpm
pg_readonly_17 1.0.3 el9.x86_64 pgdg 16.7 KiB pg_readonly_17-1.0.3-4PGDG.rhel9.x86_64.rpm
pg_readonly_17 1.0.3 el9.aarch64 pgdg 16.4 KiB pg_readonly_17-1.0.3-4PGDG.rhel9.aarch64.rpm
pg_readonly_17 1.0.3 el10.x86_64 pgdg 17.0 KiB pg_readonly_17-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_17 1.0.3 el10.aarch64 pgdg 16.9 KiB pg_readonly_17-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-17-pg-readonly 1.0.3 d12.x86_64 pigsty 19.4 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-readonly 1.0.3 d12.aarch64 pigsty 19.2 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-readonly 1.0.3 d13.x86_64 pigsty 19.4 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-readonly 1.0.3 d13.aarch64 pigsty 19.2 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-readonly 1.0.3 u22.x86_64 pigsty 23.1 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-readonly 1.0.3 u22.aarch64 pigsty 23.0 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-readonly 1.0.3 u24.x86_64 pigsty 20.2 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-17-pg-readonly 1.0.3 u24.aarch64 pigsty 19.9 KiB postgresql-17-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_readonly_16 1.0.3 el8.x86_64 pgdg 16.4 KiB pg_readonly_16-1.0.3-2.rhel8.1.x86_64.rpm
pg_readonly_16 1.0.3 el8.aarch64 pgdg 16.2 KiB pg_readonly_16-1.0.3-2.rhel8.1.aarch64.rpm
pg_readonly_16 1.0.3 el9.x86_64 pgdg 16.5 KiB pg_readonly_16-1.0.3-2.rhel9.1.x86_64.rpm
pg_readonly_16 1.0.3 el9.aarch64 pgdg 16.1 KiB pg_readonly_16-1.0.3-2.rhel9.1.aarch64.rpm
pg_readonly_16 1.0.3 el10.x86_64 pgdg 17.0 KiB pg_readonly_16-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_16 1.0.3 el10.aarch64 pgdg 16.9 KiB pg_readonly_16-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-16-pg-readonly 1.0.3 d12.x86_64 pigsty 19.4 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-readonly 1.0.3 d12.aarch64 pigsty 19.1 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-readonly 1.0.3 d13.x86_64 pigsty 19.4 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-readonly 1.0.3 d13.aarch64 pigsty 19.2 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-readonly 1.0.3 u22.x86_64 pigsty 23.0 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-readonly 1.0.3 u22.aarch64 pigsty 22.9 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-readonly 1.0.3 u24.x86_64 pigsty 20.2 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-16-pg-readonly 1.0.3 u24.aarch64 pigsty 19.9 KiB postgresql-16-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_readonly_15 1.0.3 el8.x86_64 pgdg 30.7 KiB pg_readonly_15-1.0.3-1.rhel8.x86_64.rpm
pg_readonly_15 1.0.1 el8.x86_64 pgdg 29.2 KiB pg_readonly_15-1.0.1-1.rhel8.x86_64.rpm
pg_readonly_15 1.0.3 el8.aarch64 pgdg 30.4 KiB pg_readonly_15-1.0.3-1.rhel8.aarch64.rpm
pg_readonly_15 1.0.3 el9.x86_64 pgdg 31.3 KiB pg_readonly_15-1.0.3-1.rhel9.x86_64.rpm
pg_readonly_15 1.0.1 el9.x86_64 pgdg 29.9 KiB pg_readonly_15-1.0.1-1.rhel9.x86_64.rpm
pg_readonly_15 1.0.3 el9.aarch64 pgdg 31.0 KiB pg_readonly_15-1.0.3-1.rhel9.aarch64.rpm
pg_readonly_15 1.0.3 el10.x86_64 pgdg 17.0 KiB pg_readonly_15-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_15 1.0.3 el10.aarch64 pgdg 16.9 KiB pg_readonly_15-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-15-pg-readonly 1.0.3 d12.x86_64 pigsty 19.4 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-readonly 1.0.3 d12.aarch64 pigsty 19.2 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-readonly 1.0.3 d13.x86_64 pigsty 19.3 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-readonly 1.0.3 d13.aarch64 pigsty 19.2 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-readonly 1.0.3 u22.x86_64 pigsty 23.0 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-readonly 1.0.3 u22.aarch64 pigsty 22.9 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-readonly 1.0.3 u24.x86_64 pigsty 20.2 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-15-pg-readonly 1.0.3 u24.aarch64 pigsty 19.9 KiB postgresql-15-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_readonly_14 1.0.3 el8.x86_64 pgdg 30.5 KiB pg_readonly_14-1.0.3-1.rhel8.x86_64.rpm
pg_readonly_14 1.0.1 el8.x86_64 pgdg 29.7 KiB pg_readonly_14-1.0.1-1.rhel8.x86_64.rpm
pg_readonly_14 1.0.3 el8.aarch64 pgdg 30.1 KiB pg_readonly_14-1.0.3-1.rhel8.aarch64.rpm
pg_readonly_14 1.0.3 el9.x86_64 pgdg 31.1 KiB pg_readonly_14-1.0.3-1.rhel9.x86_64.rpm
pg_readonly_14 1.0.1 el9.x86_64 pgdg 29.9 KiB pg_readonly_14-1.0.1-1.rhel9.x86_64.rpm
pg_readonly_14 1.0.3 el9.aarch64 pgdg 30.7 KiB pg_readonly_14-1.0.3-1.rhel9.aarch64.rpm
pg_readonly_14 1.0.3 el10.x86_64 pgdg 16.9 KiB pg_readonly_14-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_14 1.0.3 el10.aarch64 pgdg 16.8 KiB pg_readonly_14-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-14-pg-readonly 1.0.3 d12.x86_64 pigsty 19.1 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-readonly 1.0.3 d12.aarch64 pigsty 18.9 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-readonly 1.0.3 d13.x86_64 pigsty 19.1 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-readonly 1.0.3 d13.aarch64 pigsty 19.0 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-readonly 1.0.3 u22.x86_64 pigsty 22.8 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-readonly 1.0.3 u22.aarch64 pigsty 22.7 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-readonly 1.0.3 u24.x86_64 pigsty 19.9 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-14-pg-readonly 1.0.3 u24.aarch64 pigsty 19.7 KiB postgresql-14-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_readonly_13 1.0.3 el8.x86_64 pgdg 30.2 KiB pg_readonly_13-1.0.3-1.rhel8.x86_64.rpm
pg_readonly_13 1.0.1 el8.x86_64 pgdg 29.3 KiB pg_readonly_13-1.0.1-1.rhel8.x86_64.rpm
pg_readonly_13 1.0.3 el8.aarch64 pgdg 29.9 KiB pg_readonly_13-1.0.3-1.rhel8.aarch64.rpm
pg_readonly_13 1.0.3 el9.x86_64 pgdg 30.7 KiB pg_readonly_13-1.0.3-1.rhel9.x86_64.rpm
pg_readonly_13 1.0.1 el9.x86_64 pgdg 29.6 KiB pg_readonly_13-1.0.1-1.rhel9.x86_64.rpm
pg_readonly_13 1.0.3 el9.aarch64 pgdg 30.4 KiB pg_readonly_13-1.0.3-1.rhel9.aarch64.rpm
pg_readonly_13 1.0.3 el10.x86_64 pgdg 16.8 KiB pg_readonly_13-1.0.3-5PGDG.rhel10.x86_64.rpm
pg_readonly_13 1.0.3 el10.aarch64 pgdg 16.8 KiB pg_readonly_13-1.0.3-5PGDG.rhel10.aarch64.rpm
postgresql-13-pg-readonly 1.0.3 d12.x86_64 pigsty 18.9 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-readonly 1.0.3 d12.aarch64 pigsty 18.8 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-readonly 1.0.3 d13.x86_64 pigsty 18.9 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~trixie_amd64.deb
postgresql-13-pg-readonly 1.0.3 d13.aarch64 pigsty 18.9 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~trixie_arm64.deb
postgresql-13-pg-readonly 1.0.3 u22.x86_64 pigsty 22.5 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-readonly 1.0.3 u22.aarch64 pigsty 22.4 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-readonly 1.0.3 u24.x86_64 pigsty 19.7 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~noble_amd64.deb
postgresql-13-pg-readonly 1.0.3 u24.aarch64 pigsty 19.6 KiB postgresql-13-pg-readonly_1.0.3-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/pierreforstmann/pg_readonly
 Source Tarball
pg_readonly-1.0.3.tar.gz
 
pig build pkg pg_readonly;		# build spec not ready

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pg_readonly;		# install via package name, for the active PG version

pig install pg_readonly -v 18;   # install for PG 18
pig install pg_readonly -v 17;   # install for PG 17
pig install pg_readonly -v 16;   # install for PG 16
pig install pg_readonly -v 15;   # install for PG 15
pig install pg_readonly -v 14;   # install for PG 14
pig install pg_readonly -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_readonly;
Last updated on
pg_checksumspgdd