Extensions
anon

anon

PostgreSQL Anonymizer (anon) extension

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
7050
anon
pg_anon
2.4.1
SEC
PostgreSQL
Rust
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
See Also
faker
pgsodium
pg_tde
pgcrypto
pg_permissions
pgaudit
set_user
pg_drop_events

pgrx=0.16.1, manual updated pgrx by Vonng

Packages

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PIGSTY
2.4.1
18
17
16
15
14
13
pg_anon_$v-
Debian
PIGSTY
2.4.1
18
17
16
15
14
13
postgresql-$v-pg-anon-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
el8.aarch64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
el9.x86_64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
el9.aarch64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
el10.x86_64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
el10.aarch64
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
PIGSTY 2.4.1
d12.x86_64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
d12.aarch64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
u22.aarch64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
u24.x86_64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
u24.aarch64
MISS
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PIGSTY 2.3.0
PackageVersionOSORGSIZEFile URL
pg_anon_182.4.1el8.x86_64pigsty3.2 MiBpg_anon_18-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_182.4.1el8.aarch64pigsty2.6 MiBpg_anon_18-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_182.4.1el9.x86_64pigsty2.9 MiBpg_anon_18-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_182.4.1el9.aarch64pigsty2.7 MiBpg_anon_18-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_182.4.1el10.x86_64pigsty3.0 MiBpg_anon_18-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_182.4.1el10.aarch64pigsty2.8 MiBpg_anon_18-2.4.1-1PIGSTY.el10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
pg_anon_172.4.1el8.x86_64pigsty3.2 MiBpg_anon_17-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_172.4.1el8.aarch64pigsty2.6 MiBpg_anon_17-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_172.4.1el9.x86_64pigsty2.9 MiBpg_anon_17-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_172.4.1el9.aarch64pigsty2.7 MiBpg_anon_17-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_172.4.1el10.x86_64pigsty3.0 MiBpg_anon_17-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_172.4.1el10.aarch64pigsty2.7 MiBpg_anon_17-2.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-17-pg-anon2.3.0d12.x86_64pigsty2.3 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-anon2.3.0d12.aarch64pigsty2.1 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-anon2.3.0u22.x86_64pigsty2.6 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-anon2.3.0u22.aarch64pigsty2.5 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-anon2.3.0u24.x86_64pigsty2.6 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~noble_amd64.deb
postgresql-17-pg-anon2.3.0u24.aarch64pigsty2.4 MiBpostgresql-17-pg-anon_2.3.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_anon_162.4.1el8.x86_64pigsty3.2 MiBpg_anon_16-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_162.4.1el8.aarch64pigsty2.6 MiBpg_anon_16-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_162.4.1el9.x86_64pigsty2.9 MiBpg_anon_16-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_162.4.1el9.aarch64pigsty2.7 MiBpg_anon_16-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_162.4.1el10.x86_64pigsty3.0 MiBpg_anon_16-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_162.4.1el10.aarch64pigsty2.8 MiBpg_anon_16-2.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-16-pg-anon2.3.0d12.x86_64pigsty2.3 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-anon2.3.0d12.aarch64pigsty2.1 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-anon2.3.0u22.x86_64pigsty2.6 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-anon2.3.0u22.aarch64pigsty2.5 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-anon2.3.0u24.x86_64pigsty2.6 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~noble_amd64.deb
postgresql-16-pg-anon2.3.0u24.aarch64pigsty2.4 MiBpostgresql-16-pg-anon_2.3.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_anon_152.4.1el8.x86_64pigsty3.2 MiBpg_anon_15-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_152.4.1el8.aarch64pigsty2.6 MiBpg_anon_15-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_152.4.1el9.x86_64pigsty3.0 MiBpg_anon_15-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_152.4.1el9.aarch64pigsty2.7 MiBpg_anon_15-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_152.4.1el10.x86_64pigsty3.0 MiBpg_anon_15-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_152.4.1el10.aarch64pigsty2.8 MiBpg_anon_15-2.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-15-pg-anon2.3.0d12.x86_64pigsty2.3 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-anon2.3.0d12.aarch64pigsty2.1 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-anon2.3.0u22.x86_64pigsty2.6 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-anon2.3.0u22.aarch64pigsty2.5 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-anon2.3.0u24.x86_64pigsty2.6 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~noble_amd64.deb
postgresql-15-pg-anon2.3.0u24.aarch64pigsty2.4 MiBpostgresql-15-pg-anon_2.3.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_anon_142.4.1el8.x86_64pigsty3.2 MiBpg_anon_14-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_142.4.1el8.aarch64pigsty2.6 MiBpg_anon_14-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_142.4.1el9.x86_64pigsty2.9 MiBpg_anon_14-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_142.4.1el9.aarch64pigsty2.7 MiBpg_anon_14-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_142.4.1el10.x86_64pigsty3.0 MiBpg_anon_14-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_142.4.1el10.aarch64pigsty2.8 MiBpg_anon_14-2.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-14-pg-anon2.3.0d12.x86_64pigsty2.3 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-anon2.3.0d12.aarch64pigsty2.1 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-anon2.3.0u22.x86_64pigsty2.6 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-anon2.3.0u22.aarch64pigsty2.5 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-anon2.3.0u24.x86_64pigsty2.6 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~noble_amd64.deb
postgresql-14-pg-anon2.3.0u24.aarch64pigsty2.4 MiBpostgresql-14-pg-anon_2.3.0-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_anon_132.4.1el8.x86_64pigsty3.2 MiBpg_anon_13-2.4.1-1PIGSTY.el8.x86_64.rpm
pg_anon_132.4.1el8.aarch64pigsty2.6 MiBpg_anon_13-2.4.1-1PIGSTY.el8.aarch64.rpm
pg_anon_132.4.1el9.x86_64pigsty3.0 MiBpg_anon_13-2.4.1-1PIGSTY.el9.x86_64.rpm
pg_anon_132.4.1el9.aarch64pigsty2.7 MiBpg_anon_13-2.4.1-1PIGSTY.el9.aarch64.rpm
pg_anon_132.4.1el10.x86_64pigsty3.0 MiBpg_anon_13-2.4.1-1PIGSTY.el10.x86_64.rpm
pg_anon_132.4.1el10.aarch64pigsty2.8 MiBpg_anon_13-2.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-13-pg-anon2.3.0d12.x86_64pigsty2.4 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-anon2.3.0d12.aarch64pigsty2.1 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-anon2.3.0u22.x86_64pigsty2.7 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-anon2.3.0u22.aarch64pigsty2.5 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-anon2.3.0u24.x86_64pigsty2.6 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~noble_amd64.deb
postgresql-13-pg-anon2.3.0u24.aarch64pigsty2.4 MiBpostgresql-13-pg-anon_2.3.0-1PIGSTY~noble_arm64.deb

Source

Repository
gitlab.com/dalibo/postgresql_anonymizer/
Source Tarball
postgresql_anonymizer-2.4.1.tar.gz
pig build get anon; # get anon source code
pig build dep anon; # install build dependencies
pig build pkg anon; # build extension rpm or deb
pig build ext anon; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install anon; # install by extension name, for the current active PG version
pig ext install pg_anon; # install via package alias, for the active PG version
pig ext install anon -v 18;   # install for PG 18
pig ext install anon -v 17;   # install for PG 17
pig ext install anon -v 16;   # install for PG 16
pig ext install anon -v 15;   # install for PG 15
pig ext install anon -v 14;   # install for PG 14
pig ext install anon -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION anon CASCADE SCHEMA anon;
Last updated on
pg_session_jwtpg_tde