How to Never Lose a Transaction with pg_receivewal — pg_receivewal (formerly pg_receivexlog) streams a Postgres server or cluster’s write-ahead log in real time and can be used to avoid data loss in even ‘dire circumstances’.

Laurenz Albe

PostGIS 3.0.0: Geospatial Objects for Postgres — A long time in the coming, PostGIS 3.0 takes the popular spatial Postgres extension into the Postgres 12 world, moves raster support into a separate extension, and significantly improves performance via parallelization (a bit more about this here).

PostGIS Developers

Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Try it free with Datadog for 14 days.

Datadog sponsor

Auto Failover with PostgreSQL 12 — The team behind pg_auto_failover, an extension for automated failover for Postgres clusters, reflect on how it’s been upgraded to support Postgres 12.

Microsoft

Generating Land-Constrained Geographical Point Grids with PostGIS — I’ve never had a need to use PostGIS so far, but tutorials like this certainly make it look appealing. Clever stuff.

Alex S Korban

A Beginner’s Guide to Formatting Dates in SQL — Date and time types can often throw up challenges in SQL, so it’s good to have tutorials that reflect on the various ways to work with them.

Lori Brok

Sending Notifications From Amazon Aurora PostgreSQL — As a managed service, Amazon Aurora restricts your access to useful extensions for sending notifications directly from its Postgres-compatible database implementation.. so how can you get notifications after database jobs complete? Here’s how to do it.

Rajeshkumar Sabankar and Santhosh Kumar Adapa

E-Maj 3.2.0: A Way to Log and Rollback Table Updates — E-Maj logs updates performed on tables (of your choice) and lets you cancel/rollback such updates at will. v3.2 introduces Postgres 12 support.

Dalibo

PgBouncer 1.12.0: A Connection Pooler for Postgres — 1.12 includes fixes to SCRAM support improving interoperability with newer Postgres versions.

PgBouncer

eBook: Best Practices for Optimizing Postgres Query Performance — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook.

pganalyze sponsor

Aquameta: An Experimental Web Development Platform Built Entirely in Postgres — I’m a big fan of using the right tools for the right job, but this is an interesting project nonetheless. Apps in Aquameta are “represented entirely as relational data”.

Aquameta