#328 — October 23, 2019

Read on the Web

Note: The Tip of the Week is taking a rest for this week, but will be back soon :-)

Postgres Weekly

How to Never Lose a Transaction with pg_receivewalpg_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

📂 Code and Projects

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

🗓 Upcoming Events

  • pgDay Santiago (October 29 in Santiago, Chile) — Intended for PostgreSQL users of all levels, with talks for everyone and the chance to meet your peers.
  • PG Down Under (November 15 in Sydney, Australia) — The second outing for this annual, Australian Postgres conference.
  • PgConf.Russia (Febuary 3-5, 2020 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions.
  • PGConf India (Febuary 26-28, 2020 in Bengaluru, Maharashtra, India) — A dedicated training day and a multi-track two-day conference.
  • pgDay Paris 2020 (March 26, 2020 in Paris, France) — Learn more about the world’s most advanced open source database among your peers.