The [PostgreSQL Anonymizer](https://postgresql-anonymizer.readthedocs.io/en/stable/) 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)](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_trusted_language_extension.html) 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.

pg_anonymizer extension for RDS PostgreSQL

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.

주제

데이터베이스 마이그레이션 및 현대화 분석

태그

PostgreSQL 아마존 Relational Database Service 데이터베이스

언어

English

nikhilaws

질문됨 3달 전522회 조회

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.

전문가

Giovanni Lauria

답변함 3달 전

nikhilaws
3달 전
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?
Giovanni Lauria 전문가
3달 전
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.

pg_anonymizer extension for RDS PostgreSQL

관련 콘텐츠