hylaride 14 hours ago

It can be done manually:

https://dba.stackexchange.com/questions/306661/how-to-instal...

Reply View 1 reply
  • daamien 5 hours ago

    PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained.

    This extension is currently not available on RDS but it is available on many others DBaaS providers : Azure SQL, Google Cloud SQL, Crunchy Bridge, ....

    Reply View 0 replies
zdc1 19 hours ago

Assuming if it's for a support team or internal users with a lower SLA, I wonder if it's possible to have a small self-hosted PostgreSQL server that basically acts as a shim by holding a foreign-data wrapper connection to the actual RDS instance

Reply View 2 replies
debarshri 14 hours ago

In RDS, if you cannot use this, you can create masked view and use query rewrite to make it work.

In my experience PG anonymizer has performance issues when it comes to large queries.

Reply View 1 reply
  • daamien 5 hours ago

    Version 2.0 was released a few days ago. It's a complete rewrite in Rust.

    Performance should be better than with v1.x

    Reply View 0 replies
symfoniq 15 hours ago

Same. Lack of RDS support is the only reason we aren’t using this.

Reply View 4 replies
  • hylaride 14 hours ago

    It can be done manually:

    https://dba.stackexchange.com/questions/306661/how-to-instal...

    reply

    Reply View 1 reply
    • daamien 4 hours ago

      PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained. This extension is currently not available on RDS but it is available on many others DBaaS providers : Azure SQL, Google Cloud SQL, Crunchy Bridge, ....

      Reply View 0 replies
  • edrenova 12 hours ago

    Just to jump in here -> We support RDS + more and you can self-host, Neosync.

    https://github.com/nucleuscloud/neosync

    (I'm one of the co-founders)

    Reply View 1 reply
    • BoorishBears 11 hours ago

      I tried to figure out how/if this does what I need and your README had no examples. I clicked a couple of level deep, found no obvious demonstrations and left.

      I checked the homepage but I do not watch Loom-style demos personally, definitely not 5 minute ones, and so I left.

      -

      When I click on OP's link, or just search for it on Google, it takes less than a full page for the extension to show me an extremely straightforward demonstration of its value. You should have something like that.

      A simple example of what queries will look like, what setup will look like, all concisely communicated, no 5 minute lectures involved.

      Reply View 0 replies