noset
Module for blocking SET variables for non-super users.
Module:
Categories:
Overview
PIGSTY 3rd Party Extension: pg_noset
: Module for blocking SET variables for non-super users.
Information
- Extension ID: 7210
- Extension Name:
noset
- Package Name:
pg_noset
- Category:
SEC
- License: AGPLv3
- Website: https://gitlab.com/ongresinc/extensions/noset
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 0.3.0
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
noset_$v*
- RPM Ver :
0.3.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-noset
- DEB Ver :
0.3.0
- DEB Deps: N/A
Packages
OS | Arch | PG17 | PG16 | PG15 | PG14 | PG13 |
---|---|---|---|---|---|---|
el8 |
x86_64 |
noset_17 PIGSTY 0.3.0 |
noset_16 PIGSTY 0.3.0 |
noset_15 PIGSTY 0.3.0 |
noset_14 PIGSTY 0.3.0 |
noset_13 PIGSTY 0.3.0 |
el8 |
aarch64 |
noset_17 PIGSTY 0.3.0 |
noset_16 PIGSTY 0.3.0 |
noset_15 PIGSTY 0.3.0 |
noset_14 PIGSTY 0.3.0 |
noset_13 PIGSTY 0.3.0 |
el9 |
x86_64 |
noset_17 PIGSTY 0.3.0 |
noset_16 PIGSTY 0.3.0 |
noset_15 PIGSTY 0.3.0 |
noset_14 PIGSTY 0.3.0 |
noset_13 PIGSTY 0.3.0 |
el9 |
aarch64 |
noset_17 PIGSTY 0.3.0 |
noset_16 PIGSTY 0.3.0 |
noset_15 PIGSTY 0.3.0 |
noset_14 PIGSTY 0.3.0 |
noset_13 PIGSTY 0.3.0 |
d12 |
x86_64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
d12 |
aarch64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
u22 |
x86_64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
u22 |
aarch64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
u24 |
x86_64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
u24 |
aarch64 |
postgresql-17-noset PIGSTY 0.3.0 |
postgresql-16-noset PIGSTY 0.3.0 |
postgresql-15-noset PIGSTY 0.3.0 |
postgresql-14-noset PIGSTY 0.3.0 |
postgresql-13-noset PIGSTY 0.3.0 |
Installation
Install noset
via the pig
CLI tool:
pig ext install pg_noset; # Extension Namepig ext install noset; # normalized package name
Install pg_noset
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_noset"]}' # -l <cls>
Install pg_noset
RPM from YUM repo directly:
dnf install noset_17*;
dnf install noset_16*;
dnf install noset_15*;
dnf install noset_14*;
dnf install noset_13*;
Install pg_noset
DEB from APT repo directly:
apt install postgresql-17-noset;
apt install postgresql-16-noset;
apt install postgresql-15-noset;
apt install postgresql-14-noset;
apt install postgresql-13-noset;
Extension noset
has to be added to shared_preload_libraries
shared_preload_libraries = 'noset'; # add to pg cluster config
Enable noset
extension on PostgreSQL cluster:
CREATE EXTENSION noset;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.