Discovering Lesser-Known PostgreSQL 12 Features — If you’re an ardent Postgres Weekly reader, you’ll know about a few of these, but 12 was such a big release that there were lots of minor improvements people haven’t blogged about yet.

Kaarel Moppel

Playing with Postgres's 'SQL Beautification' Skills — It’s common to use a ‘SQL beautifier’ to turn otherwise ugly queries into more attractively formatted strings.. but did you know Postgres has some built-in functionality you can misuse to similar ends? I’m not sure how useful this is but it’s an interesting corner of Postgres to be aware of.

Hans-Jürgen Schönig

Managed PostgreSQL by DigitalOcean — Deploy a highly scalable PostgreSQL cluster with no admin overhead.

DigitalOcean sponsor

Hope Is Not A Strategy: How Hardware Issues Can Affect Your Postgres Data — Not a technical post, but more a lesson or words of advice. A recent announcement by HPE (Hewlett Packard Enterprise) about some SSDs that would fail suddenly after 32,768 hours of operation might give you some food for thought as to how you’d deal with such a failure in your own setup.

Joe Conway

Setting SSL/TLS Protocol Versions in Postgres 12 — ssl_min_protocol_version and ssl_max_protocol_version are two new config settings to control the lowest and highest versions of the SSL/TLS protocol family you want Postgres to support.

Peter Eisentraut

A Postgres 12 Improvement: Fewer Benign Log Entries — A look at a surprisingly minor Postgres 12 improvement, but in the long run, fewer unnecessary log messages like this one can only be a good thing.

Jobin Augustine

Top Ten Reasons to Migrate from Oracle to Postgres — We’re no doubt preaching to the converted here (!) but if you know someone considering the move, here’s some of the advantages of migrating from Oracle to Postgres.

Paul Namuag

pg-structure: Extract the Structure of a Database into JavaScript — Provides a mechanism for ‘reverse engineering’ a Postgres database by letting you quickly grab hold of tables, columns, indexes, schemas, etc.

Özüm Eldoğan

Crunchy High-Availability PostgreSQL Keeps Critical Applications Up — Leverage trusted open source software to ensure your PostgreSQL data is always available.

Crunchy Data sponsor

pg_variables: Session Wide Variables for Postgres

Postgres Professional

Azure Database for PostgreSQL: Hyperscale (Citus) Now Generally Available — Citus, now a Microsoft technology, transforms a Postgres database into something that can easily scale horizontally (if you’re on Azure, naturally).

Craig Kerstiens (Microsoft)