Streaming obfuscator of sensitive data in PostgreSQL dumps (pg_dump).
$ git clone https://github.com/ostrovok-team/pgdump-obfuscator $ cd pgdump-obfuscator $ go test $ go install $ pg_dump [...] |pgdump-obfuscator |less # inspect
pgdump-obfuscator -h Usage of ./pgdump-obfuscator: -c value Configs, example: auth_user:email:email, auth_user:password:bytes ...
That mean you can provide as many "-c option" as you need.
pgdump-obfuscator -c auth_user:email:email -c auth_user:password:bytes -c address_useraddress:phone_number:digits -c address_useraddress:land_line:digits
Idea: Denis Orlikhin https://github.com/overplumbum
Initial implementation: Sergey Shepelev https://github.com/temoto
pgdump-obfuscator was implemented during a hackathon at http://ostrovok.ru/ big thanks to Evgeny Kuryshev and everyone involved in organization of this event.