---
title: "PostgreSQL Anonymizer: A Tool to Mask Personal Information"
publication: "Postgres Weekly"
issue: 280
published_at: "2018-10-31"
canonical_url: "https://postgresweekly.com/issues/280"
---

The latest Postgres news, articles, tools, and projects.       

#280 — October 31, 2018 

[Read on the Web](https://postgresweekly.com/issues/280)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/lryxyrsuvdnx96r0x8tr.jpg)](http://blog.taadeem.net///english/2018/10/29/Introducing-PostgreSQL-Anonymizer)  

[PostgreSQL Anonymizer: A Tool to Mask Personal Information](http://blog.taadeem.net///english/2018/10/29/Introducing-PostgreSQL-Anonymizer) — An introduction to a new Postgres extension for masking or replacing personally identifiable information (PII) which may be necessary for protecting commercially sensitive data or for complying with regulations like GDPR. 

Damien Clochard   

[The Biggest Mistake Postgres Ever Made](http://www.craigkerstiens.com/2018/10/30/postgres-biggest-mistake/) — A brief piece on confusion over the name of our favorite database, which some people call PostgreSQL, some Postgres, and some even _Postgre_. 

Craig Kerstiens   [![\](https://copm.s3.amazonaws.com/806e66c4.png)](https://pgexperts.com/) 

[Because Your Data Is Your Business](https://pgexperts.com/) — PostgreSQL Experts provides full-stack support for PostgreSQL, including database tuning, emergency support, and remote DBA services, including 24x7 support. 

PostgreSQL Experts, Inc. sponsor   

[A 3 Part Series on Postgres Locking](https://www.percona.com/blog/2018/10/16/postgresql-locking-part-1-row-locks/) — An understanding of PostgreSQL locking is important to build scalable applications and avoid downtime. This series covers row locks, [table-level locks](https://www.percona.com/blog/2018/10/24/postgresql-locking-part-2-heavyweight-locks/) and [lightweight locks.](https://www.percona.com/blog/2018/10/30/postgresql-locking-part-3-lightweight-locks/) 

Nickolay Ihalainen   

[PipelineDB 1.0: An Extension for High-Perf Time-Series Aggregation](https://www.pipelinedb.com/blog/pipelinedb-1-0-0-high-performance-time-series-aggregation-for-postgresql) — A Postgres extension for high-performance time-series aggregation via continuous SQL queries. 

Derek Nelson   

[Postgres 12 To Introduce a `pg_promote` Function](https://www.depesz.com/2018/10/30/waiting-for-postgresql-12-add-pg_promote-function/) — With this new SQL-callable function, you’ll be able to promote a standby. 

Hubert depesz Lubaczewski   

[The Evolution of Partitioning from Postgres 9.6 to 11](https://blog.2ndquadrant.com/partitioning-evolution-postgresql-11/) — Postgres partitioning first landed in 9.6. It has continued to get updates and now with newly released Postgres 11 is feature rich. 

David Rowley (2ndQuadrant)   

[How to Set Up scram-sha-256 Authentication in Postgres](http://hacksoclock.blogspot.com/2018/10/how-to-set-up-scram-sha-256.html) 

Quinn Weaver   

[Recreating a Column Oriented Database in Postgres](https://www.brianlikespostgres.com/poor-mans-column-oriented-database.html) — This is _rather niche_, but you may find this experiment in making Postgres act more like a column oriented DB interesting. 

Brian Davis   

[Peeking at the Query Performance of Postgres 11](https://www.cybertec-postgresql.com/en/peeking-at-query-performance-of-the-upcoming-version-11-of-postgresql/) 

Kaarel Moppel   

[Announcing: EDB Postgres Migration Portal Beta 3 Release](https://bit.ly/2NGkuuv) 

EnterpriseDB sponsor   

[`pgenv` Gets Patching Support](https://fluca1978.github.io/2018/10/31/pgenv_patching.html) — [pgenv](https://github.com/theory/pgenv) is a utility to build and run different releases of Postgres and now supports customizable patching. 

Luca Ferrari  

🗓 Events  

[PGDay.Seoul 2018](http://pgday.postgresql.kr) — **November 3 (Seoul, South Korea)** PostgreSQL Korean Users group prepared the third half day event. All presentations are in Korean.   

[Pg Down Under 2018](https://2018.pgdu.org/) — **December 7 (Melbourne, Australia)** PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.   

[PGConf.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **December 10-12 (Tokyo, Japan)** The largest PostgreSQL event in Asia.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom