--- title: "PostGIS 3.0 released" publication: "Postgres Weekly" issue: 328 published_at: "2019-10-23" canonical_url: "https://postgresweekly.com/issues/328" --- The latest Postgres news, articles, tools, and projects. #328 — October 23, 2019 [Read on the Web](https://postgresweekly.com/issues/328) Note: The _Tip of the Week_ is taking a rest for this week, but will be back soon :-) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/jiagvjutiltfsgdchttw.jpg)](https://www.cybertec-postgresql.com/en/never-lose-a-postgresql-transaction-with-pg_receivewal/) [How to Never Lose a Transaction with `pg_receivewal`](https://www.cybertec-postgresql.com/en/never-lose-a-postgresql-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](http://postgis.net/2019/10/20/postgis-3.0.0/) — 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](https://carto.com/blog/postgis-3-release/)). PostGIS Developers [![\](https://copm.s3.amazonaws.com/3b09a7d8.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) [Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) — 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](https://techcommunity.microsoft.com/t5/Azure-Database-for-PostgreSQL/Auto-Failover-with-PostgreSQL-12/ba-p/917637) — The team behind [`pg_auto_failover`](https://github.com/citusdata/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](https://korban.net/posts/postgres/2019-10-17-generating-land-constrained-point-grids/) — 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](https://blog.panoply.io/a-beginners-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](https://aws.amazon.com/blogs/database/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](https://www.postgresql.org/about/news/1983/) — 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](https://www.pgbouncer.org/2019/10/pgbouncer-1-12-0) — 1.12 includes fixes to SCRAM support improving interoperability with newer Postgres versions. PgBouncer [eBook: Best Practices for Optimizing Postgres Query Performance](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklySecondary) — 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](https://github.com/aquametalabs/aquameta) — 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](https://www.pgday.cl/2019/) (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](https://pgdu.org/) (November 15 in Sydney, Australia) — The second outing for this annual, Australian Postgres conference. - [PgConf.Russia](https://pgconf.ru/2020) (Febuary 3-5, 2020 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions. - [PGConf India](https://pgconf.in/conferences/pgconfin2020) (Febuary 26-28, 2020 in Bengaluru, Maharashtra, India) — A dedicated training day and a multi-track two-day conference. - [pgDay Paris 2020](https://2020.pgday.paris/#%2319) (March 26, 2020 in Paris, France) — Learn more about the world’s most advanced open source database among your peers. Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), 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