Since version 0.9 of PostgreSQL Anonymizer, you can't install it on Amazon RDS anymore since the extension anon is not added to Amazon RDS yet (by Amazon). For the time being we could install version 0.8.1 of PostgreSQL Anonymizer. This question is to get answered how to perform that installation which I'm going to try and document myself.


Related Q&A: https://stackoverflow.com/a/69295102/1385429

1 Answer 1


The answer is described mostly already here. I'll add it here as well to make it a bit easier to find and understand.

## clone the repo en cd into it
git clone https://gitlab.com/dalibo/postgresql_anonymizer.git
cd ./postgresql_anonymizer

## Checkout the version that allows standalone installation
git checkout 0.8.1

## Create the anon_standalone.sql file
make standalone

## Execute that sql file against your Amazon RDS instance
psql -h <host> -U <username> -d <database-name> -a -f anon_standalone.sql


Not the answer you're looking for? Browse other questions tagged or ask your own question.