Install With PGXN :
This is the recommended way to install the extension
sudo apt install pgxnclient (or pip install pgxn) sudo pgxn install ddlx sudo pgxn install postgresql_anonymizer
Install From source
First you need to install the postgresql development libraries. On most
distribution, this is available through a package called
Then build the project like any other PostgreSQL extension:
make extension sudo make install
Install in the cloud
Generally Database As A Service operators ( such as Amazon RDS ) do not allow their clients to load any extension. Instead they support only a limited subset of extensions, such as PostGIS or pgcrypto. You can ask them if they plan to support this one in the near future, but I wouldn't bet my life on it 😃
However this tool is set of plpgsql functions, which means should you be able to install it directly without declaring an extension.
Here's a few steps to try it out:
$ git clone https://gitlab.com/dalibo/postgresql_anonymizer.git $ make standalone $ psql ..... -f anon_standalone_PG11.sql
NB : Replace
PG11 with the version of Postgres offered by your DBaaS operator.
When you activate the masking engine, you need to disable
SELECT anon.start_dynamic_masking( autoload := FALSE );
However if privacy and anonymity are a concern to you, hosting your data on someone else's computer is probably not a clever idea. But then again, what do I know...