Extensions
noset

noset

pg_noset : Module for blocking SET variables for non-super users.

Overview

ID Extension Package Version Category License Language
7210
noset
pg_noset
 0.3.0
SEC
AGPL-3.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd-r
No
Yes
Yes
Yes
yes
no
Relationships
See Also
pg_readonly
pg_permissions
set_user
pgaudit
login_hook
sepgsql
safeupdate
credcheck

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 0.3.0
18
17
16
15
14
13
 pg_noset -
RPM
PIGSTY
 0.3.0
18
17
16
15
14
13
 noset_$v* -
DEB
PIGSTY
 0.3.0
18
17
16
15
14
13
 postgresql-$v-noset -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el8.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el9.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el9.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el10.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el10.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d12.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d12.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d13.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d13.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u22.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u22.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u24.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u24.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
Package Version OS ORG SIZE File URL
noset_18 0.3.0 el8.x86_64 pigsty 15.6 KiB noset_18-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_18 0.3.0 el8.aarch64 pigsty 15.4 KiB noset_18-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_18 0.3.0 el9.x86_64 pigsty 15.9 KiB noset_18-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_18 0.3.0 el9.aarch64 pigsty 15.4 KiB noset_18-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_18 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_18-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_18 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_18-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-18-noset 0.3.0 d12.x86_64 pigsty 27.3 KiB postgresql-18-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-18-noset 0.3.0 d12.aarch64 pigsty 27.1 KiB postgresql-18-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-18-noset 0.3.0 d13.x86_64 pigsty 27.3 KiB postgresql-18-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-18-noset 0.3.0 d13.aarch64 pigsty 27.0 KiB postgresql-18-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-18-noset 0.3.0 u22.x86_64 pigsty 28.9 KiB postgresql-18-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-18-noset 0.3.0 u22.aarch64 pigsty 28.7 KiB postgresql-18-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-18-noset 0.3.0 u24.x86_64 pigsty 28.3 KiB postgresql-18-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-18-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-18-noset_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
noset_17 0.3.0 el8.x86_64 pigsty 15.6 KiB noset_17-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_17 0.3.0 el8.aarch64 pigsty 15.4 KiB noset_17-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_17 0.3.0 el9.x86_64 pigsty 16.0 KiB noset_17-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_17 0.3.0 el9.aarch64 pigsty 15.6 KiB noset_17-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_17 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_17-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_17 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_17-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-17-noset 0.3.0 d12.x86_64 pigsty 27.3 KiB postgresql-17-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-noset 0.3.0 d12.aarch64 pigsty 27.0 KiB postgresql-17-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-noset 0.3.0 d13.x86_64 pigsty 27.3 KiB postgresql-17-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-17-noset 0.3.0 d13.aarch64 pigsty 27.0 KiB postgresql-17-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-17-noset 0.3.0 u22.x86_64 pigsty 32.8 KiB postgresql-17-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-17-noset 0.3.0 u22.aarch64 pigsty 32.6 KiB postgresql-17-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-17-noset 0.3.0 u24.x86_64 pigsty 28.3 KiB postgresql-17-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-17-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-17-noset_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
noset_16 0.3.0 el8.x86_64 pigsty 15.6 KiB noset_16-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_16 0.3.0 el8.aarch64 pigsty 15.4 KiB noset_16-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_16 0.3.0 el9.x86_64 pigsty 16.0 KiB noset_16-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_16 0.3.0 el9.aarch64 pigsty 15.6 KiB noset_16-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_16 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_16-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_16 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_16-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-16-noset 0.3.0 d12.x86_64 pigsty 27.3 KiB postgresql-16-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-noset 0.3.0 d12.aarch64 pigsty 27.0 KiB postgresql-16-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-noset 0.3.0 d13.x86_64 pigsty 27.3 KiB postgresql-16-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-16-noset 0.3.0 d13.aarch64 pigsty 27.0 KiB postgresql-16-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-16-noset 0.3.0 u22.x86_64 pigsty 32.2 KiB postgresql-16-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-16-noset 0.3.0 u22.aarch64 pigsty 32.0 KiB postgresql-16-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-16-noset 0.3.0 u24.x86_64 pigsty 28.3 KiB postgresql-16-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-16-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-16-noset_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
noset_15 0.3.0 el8.x86_64 pigsty 15.6 KiB noset_15-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_15 0.3.0 el8.aarch64 pigsty 15.5 KiB noset_15-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_15 0.3.0 el9.x86_64 pigsty 16.0 KiB noset_15-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_15 0.3.0 el9.aarch64 pigsty 15.6 KiB noset_15-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_15 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_15-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_15 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_15-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-15-noset 0.3.0 d12.x86_64 pigsty 27.3 KiB postgresql-15-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-noset 0.3.0 d12.aarch64 pigsty 27.0 KiB postgresql-15-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-noset 0.3.0 d13.x86_64 pigsty 27.3 KiB postgresql-15-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-15-noset 0.3.0 d13.aarch64 pigsty 27.0 KiB postgresql-15-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-15-noset 0.3.0 u22.x86_64 pigsty 32.2 KiB postgresql-15-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-15-noset 0.3.0 u22.aarch64 pigsty 32.0 KiB postgresql-15-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-15-noset 0.3.0 u24.x86_64 pigsty 28.3 KiB postgresql-15-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-15-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-15-noset_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
noset_14 0.3.0 el8.x86_64 pigsty 15.6 KiB noset_14-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_14 0.3.0 el8.aarch64 pigsty 15.4 KiB noset_14-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_14 0.3.0 el9.x86_64 pigsty 16.0 KiB noset_14-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_14 0.3.0 el9.aarch64 pigsty 15.6 KiB noset_14-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_14 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_14-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_14 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_14-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-14-noset 0.3.0 d12.x86_64 pigsty 27.3 KiB postgresql-14-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-noset 0.3.0 d12.aarch64 pigsty 27.0 KiB postgresql-14-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-noset 0.3.0 d13.x86_64 pigsty 27.3 KiB postgresql-14-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-14-noset 0.3.0 d13.aarch64 pigsty 27.0 KiB postgresql-14-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-14-noset 0.3.0 u22.x86_64 pigsty 31.0 KiB postgresql-14-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-14-noset 0.3.0 u22.aarch64 pigsty 30.8 KiB postgresql-14-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-14-noset 0.3.0 u24.x86_64 pigsty 28.3 KiB postgresql-14-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-14-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-14-noset_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
noset_13 0.3.0 el8.x86_64 pigsty 15.5 KiB noset_13-0.3.0-1PIGSTY.el8.x86_64.rpm
noset_13 0.3.0 el8.aarch64 pigsty 15.4 KiB noset_13-0.3.0-1PIGSTY.el8.aarch64.rpm
noset_13 0.3.0 el9.x86_64 pigsty 15.9 KiB noset_13-0.3.0-1PIGSTY.el9.x86_64.rpm
noset_13 0.3.0 el9.aarch64 pigsty 15.6 KiB noset_13-0.3.0-1PIGSTY.el9.aarch64.rpm
noset_13 0.3.0 el10.x86_64 pigsty 15.6 KiB noset_13-0.3.0-1PIGSTY.el10.x86_64.rpm
noset_13 0.3.0 el10.aarch64 pigsty 15.6 KiB noset_13-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-13-noset 0.3.0 d12.x86_64 pigsty 27.2 KiB postgresql-13-noset_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-noset 0.3.0 d12.aarch64 pigsty 27.0 KiB postgresql-13-noset_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-noset 0.3.0 d13.x86_64 pigsty 27.1 KiB postgresql-13-noset_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-13-noset 0.3.0 d13.aarch64 pigsty 27.1 KiB postgresql-13-noset_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-13-noset 0.3.0 u22.x86_64 pigsty 30.8 KiB postgresql-13-noset_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-13-noset 0.3.0 u22.aarch64 pigsty 30.5 KiB postgresql-13-noset_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-13-noset 0.3.0 u24.x86_64 pigsty 28.2 KiB postgresql-13-noset_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-13-noset 0.3.0 u24.aarch64 pigsty 27.9 KiB postgresql-13-noset_0.3.0-1PIGSTY~noble_arm64.deb

Source

Repository
gitlab.com/ongresinc/extensions/noset
 Source Tarball
noset-v0.3.0.tar.gz
 
pig build pkg pg_noset;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install pg_noset;		# install via package name, for the active PG version
pig install noset;		# install by extension name, for the current active PG version

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

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'noset';

Create this extension with:

CREATE EXTENSION noset;
Last updated on
sslutilssepgsql