pg_anonymizer extension for RDS PostgreSQL
0
The PostgreSQL Anonymizer is a popular extension for masking data on query results. This is unfortunately not yet supported on RDS. One possibility is to use the Trusted Language Extensions (TLE) to have a custom extension but it only supports javascript, perl and pl/SQL extensions. Are there any other opensource alternatives that can work with RDS PostgreSQL being used for this purpose? We also have python equivalent of the extension code but unsure if this is currently supported.
Sprache
English
gefragt vor 3 Monaten528 Aufrufe
1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
1
Python is not currently supported in TLE, but you have Pigsty which is an open-source, PostgreSQL distribution that can serve as a free RDS alternative.
However, it might require more setup and maintenance compared to using RDS.
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 9 Monaten- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
Thanks for the insight. Any other extension for data masking you may be aware of that uses a supported language of tle and can work with RDS?
Found out PostgreSQL Views can do the trick natively https://stackoverflow.com/questions/71607875/data-masking-using-postgresql-at-amazon-rds-how-to
Accept the answer if ok.