Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 221 — August 23, 2017
How Postgres Makes Transactions Atomic
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
This successor to WAL-E, an archival restoration tool for Postgres, is a rewrite with over 4x performance. GitHub repo.
citusdata   #tools 
OmniDB 2.0: A Browser-Based Postgres Management Tool
An interactive, browser-based tool for working with Postgres. Written in Python and open source. Downloads here.
2nd Quadrant   #tools 
Google Developer Days – Europe is coming to Krakow on 5-6 September
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 
Autovacuum Wraparound Protection in Postgres
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
Newly released versions of PostgreSQL fix three security vulnerabilities and over 50 other bugs. A further writeup on a security release we linked last week.
Lucian Constantin   #news 
Google Cloud SQL for Postgres Updated with New Extensions
More data types, PostGIS support, cryptography, and more.
Greg Wilson   #news 
PostgresOpen Silicon Valley: A Look At The Schedule
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
An unusual trick for if your primary key column sequence reaches its limit.
Jake Swanson
PostGIS's Geography Type Is Not Limited to Earth
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
Gabriel Garrido Calvo
Work Smarter with SelectStar
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)
Vladimir Mihailenco   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.