---
title: "#221: WAL-G - Faster Disaster Recovery for Postgres"
publication: "Postgres Weekly"
issue: 221
published_at: "2017-08-23"
canonical_url: "https://postgresweekly.com/issues/221"
---

Postgres Weekly 221   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 221 — August 23, 2017     

[How Postgres Makes Transactions Atomic](https://brandur.org/postgres-atomicity?utm_source=postgresweekly&utm_medium=email)Ever heard about transactions and atomicity but weren’t sure exactly how Postgres did it? This great in-depth read will teach you all you want to know about how it works. brandur.​org [Introducing WAL-G: Faster Disaster Recovery for Postgres](https://www.citusdata.com/blog/2017/08/18/introducing-wal-g-faster-restores-for-postgres/?utm_source=postgresweekly&utm_medium=email)This successor to WAL-E, an archival restoration tool for Postgres, is a rewrite with over 4x performance. [GitHub repo.](https://github.com/wal-g/wal-g) citusdata#tools [OmniDB 2.0: A Browser-Based Postgres Management Tool](https://www.postgresql.org/about/news/1775/?utm_source=postgresweekly&utm_medium=email)An interactive, browser-based tool for working with Postgres. Written in Python and [open source.](https://github.com/OmniDB/OmniDB) [Downloads here.](https://omnidb.org/index.php/en/downloads-en) 2nd Quadrant#tools [Google Developer Days – Europe is coming to Krakow on 5-6 September](https://developers.google.com/events/gdd-europe/?utm_source=cooperpress&utm_medium=postgresweekly&utm_campaign=gddeurope)We are excited to be coming to Krakow with the latest developer updates and talks by Googlers and experts. Check our event page for more information about our schedule, speakers and live stream. Google, Inc.​ #sponsored[![\](https://copm.s3.amazonaws.com/d718c515.jpg)](https://developers.google.com/events/gdd-europe/?utm_source=cooperpress&utm_medium=postgresweekly&utm_campaign=gddeurope) [Autovacuum Wraparound Protection in Postgres](http://www.cybertec.at/autovacuum-wraparound-protection-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Most people have a complicated relationship with vacuum and Postgres. Here’s a look at why it exists and how it can help prevent transaction ID wraparound. Hans-Juergen Schoenig [PostgreSQL Gets a Fix for a Passwordless Authentication Flaw](https://thenewstack.io/passwordless-authentication-flaw-fixed-postgresql/?utm_source=postgresweekly&utm_medium=email)Newly released versions of PostgreSQL fix three security vulnerabilities and over 50 other bugs. A further writeup on a [security release](https://www.postgresql.org/about/news/1772/) we linked last week. Lucian Constantin#news [Google Cloud SQL for Postgres Updated with New Extensions](https://cloudplatform.googleblog.com/2017/08/Cloud-SQL-for-PostgreSQL-updated-with-new-extensions.html?utm_source=postgresweekly&utm_medium=email)More data types, PostGIS support, cryptography, and more. Greg Wilson#news [PostgresOpen Silicon Valley: A Look At The Schedule](https://2017.postgresopen.org/blog-schedule-live/?utm_source=postgresweekly&utm_medium=email)PostgresOpen Silicon Valley is just a few weeks away. If you’re near SF and into Postgres here’s a look at some of the talks, should you be up for checking it out. US PostgreSQL Association#news [The Night the PostgreSQL IDs Ran Out](https://medium.com/@jakswa/the-night-the-postgresql-ids-ran-out-9430a2dbb895?utm_source=postgresweekly&utm_medium=email)An unusual trick for if your primary key column sequence reaches its limit. Jake Swanson [PostGIS's Geography Type Is Not Limited to Earth](http://www.bostongis.com/blog/index.php/archives/266-geography-type-is-not-limited-to-earth.html?utm_source=postgresweekly&utm_medium=email)The audience is probably limited for this one but PostGIS can support _any_ spheroidal spatial reference system, as seen here. Regina Obe [Migrating 1200 Databases From MySQL to Postgres](http://psyenix.blogspot.com/2017/08/migrating-1200-db-from-mysql-to-postgres.html?utm_source=postgresweekly&utm_medium=email) Gabriel Garrido Calvo [Work Smarter with SelectStar](https://selectstar.io/blog/3-strategies-to-improve-postgresql-performance-schemas/?utm_source=sponsored=email=08+23+2017+Postgres+Weekly)See how SelectStar can expertly monitor schemas in your Postgres environment. Start your free trial today. SelectStar#sponsored [pg: A Postgres Featured Oriented Client and ORM for Go(lang)](https://github.com/go-pg/pg?utm_source=postgresweekly&utm_medium=email) Vladimir Mihailenco#code    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/221) [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