---
title: "The PostgreSQL Security Technical Implementation Guide (#201)"
publication: "Postgres Weekly"
issue: 201
published_at: "2017-04-05"
canonical_url: "https://postgresweekly.com/issues/201"
---

Postgres Weekly 201   . 

[Read this on the Web](http://postgresweekly.com/issues/201) 

[Postgres Weekly](http://postgresweekly.com) Issue 201 — April 5, 2017     

[Building A Scalable Time-Series Database on Postgres](https://blog.timescale.com/when-boring-is-awesome-building-a-scalable-time-series-database-on-postgresql-2900ea453ee2?utm_source=postgresweekly&utm_medium=email)We linked [TimescaleDB](http://www.timescale.com/?utm_source=postgresweekly&utm_medium=email) 2 weeks ago, but here’s some more background to the project. Ajay Kulkarni [AgensGraph: A Transactional Graph Database based on Postgres](https://github.com/bitnine-oss/agensgraph?utm_source=postgresweekly&utm_medium=email)An open source, multi-model database which supports both relational and graph-based data models, even supporting both SQL and openCypher within the same query. bitnine#code [The PostgreSQL Security Technical Implementation Guide](http://info.crunchydata.com/blog/postgres-stig-disa-security-guide?utm_source=postgresweekly&utm_medium=email)A look at the United States Defense Information Systems Agency’s (DISA) new Postgres security guide and whether it could be useful for you. Joe Conway#tutorial [24/7 PostgreSQL support with guaranteed response & resolution times](https://2ndquadrant.com/en/support/support-postgresql/)When it's critical, you can count on us! A Platinum service plan with 2ndQuadrant is all the insurance you need for when things don't go according to plan. Giving you a quick database recovery, with as little downtime as possible. 2ndQuadrant PostgreSQL Services#sponsored[![\](https://copm.s3.amazonaws.com/eecd6038.jpg)](https://2ndquadrant.com/en/support/support-postgresql/) [Distributed COUNT(DISTINCT) with HLL on Postgres](https://www.citusdata.com/blog/2017/04/04/distributed_count_distinct_with_postgresql/?utm_source=postgresweekly&utm_medium=email)In a large distributed system, using `COUNT(*)` can prove tricky but probabilistic algorithms could help you more quickly get ‘close enough’. This post looks at HyperLoglog and how you can use it in a distributed fashion. Citus Data [PgUS: The United States PostgreSQL Association](https://postgresql.us/?utm_source=postgresweekly&utm_medium=email)Little known to many, there’s a full non-profit organization behind Postgres. They’ve just gotten an updated website and it’s worth considering becoming a member. PostgreSQL#news [How to Query JSONB in Postgres, A Beginner's Cheat Sheet](https://hackernoon.com/how-to-query-jsonb-beginner-sheet-cheat-4da3aa5082a3?utm_source=postgresweekly&utm_medium=email)This handy cheat sheet gives you many of the key things you’ll want to know as you start using and querying with JSONB in Postgres. hackernoon.​com#tutorial [PgConf US 2017 Concludes; Organizers Share Some Thoughts](http://blog.pgconf.us/2017/04/its-done-postgresql-community-rocks.html?utm_source=postgresweekly&utm_medium=email)It’s now the largest PostgreSQL conference globally. Joshua Drake#opinion [Streaming Postgres to Kafka and Maintaining Consistency and Transaction Isolation](https://dunningpostor.com/streaming-postgres-to-kafka-and-maintaining-consistency-and-transaction-isolation/?utm_source=postgresweekly&utm_medium=email) Alex Matchneer#opinion [Waiting for Postgres 10: Full Text Search Support for JSONB](https://www.depesz.com/2017/04/04/waiting-for-postgresql-10-full-text-search-support-for-json-and-jsonb/?utm_source=postgresweekly&utm_medium=email)Postgres 10 is starting to shape up and while there’s some excitement around parallelism and other improvements, JSONB is getting an improvement as well: full text search. Hubert depesz Lubaczewski [JSON in Postgres: The Present and Future (PDF)](http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgconf.us-2017.pdf?utm_source=postgresweekly&utm_medium=email)JSONB is awesome in Postgres, it’s a document store in a relational database that you can index. In Postgres 10 it gets full text search. This deck from PGConf NY highlights what there is today and what’s to come. Oleg Bartunov [PostgresOpen Silicon Valley - Call For Papers Open](https://2017.postgresopen.org/callforpapers/?utm_source=postgresweekly&utm_medium=email)PostgresOpen has joined forces with PGConf SV this year for a bigger show right in downtown San Francisco this September. United States PostgreSQL Association [Safe and Unsafe Operations for High Volume PostgreSQL](http://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql?utm_source=postgresweekly&utm_medium=email#.WOPAvBLyuV5)Postgres is generally a friendly database, but when dealing with larger datasets you should use caution with some operations. Alexey Vasiliev [Using Row Level Security with A Django Application](http://www.pinaraf.info/2017/03/using-row-level-security-with-a-django-application/?utm_source=postgresweekly&utm_medium=email)Row level security (recently added to Postgres) offers some added security should you need it for compliance or other reasons. Here’s a guide on how you can get started using it with Django. Pierre Ducroquet [Debezium: Stream Changes From Your Databases](http://debezium.io/?utm_source=postgresweekly&utm_medium=email)An open source tool that captures row level changes in MySQL, MongoDB or Postgres databases so your apps can see and react to those changes. Red Hat#tools [The Future of Enterprise Postgres and Open Source Data Management](http://www.postgresvision.com)Save $200 - use code PGWEEK by May 19 to explore Postgres innovation at Postgres Vision Boston June 26-28. Postgres Vision 2017#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/201) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK