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 203 — April 19, 2017
Speeding up Postgres Restores: A 2 Part Series
Whether it’s for disaster recovery or a production-to-staging migration, backups are always useful to have. In this series, we learn how to make the restoration process go faster. Part 1 was written last year, but part 2, written this week, is now available.
Adam McKerlie   #tutorial 
Writing Postgres Triggers in Go
Uses a Go shared library with C bindings to create an insert/update trigger.
RapidLoop   #tutorial 
Patroni: A Template for PostgreSQL High Availability
High availability in Postgres still isn’t turnkey out of core. If you’re not running on a managed service, Patroni from Zalando is one option to help.
Zalando SE   #code 
2ndQuadrant Remote DBA experts save your business money
We eliminate the hassle of monitoring and managing your database; ensuring it’s always performing its best and preempt issues that could cause downtime. Remote monitoring allows us to act fast, saving money and reducing the impact of failure.
2ndQuadrant PostgreSQL Services    #sponsored 
Safe and Unsafe Operations for High Volume PostgreSQL
By default, Postgres is fairly safe and stable, but at large volumes there are a things to be cautious of. If you’re running a large scale database these tips could help you out.
Alexey Vasiliev
Running Out of IDs
“Keep on using serial for most use cases and keep bigserial in your back pocket if a real need arises.”
Josh Branchaud
Messing with PostgreSQL Users and Permissions
Postgres has robust support for various security permissions of different roles and users. Here’s a primer on getting starting with them, setting up a read-only user and related details.
Jay Marcyes   #tutorial 
Inside the WAL (Write-Ahead Log)
A quick look at what’s really in the WAL.
Bruce Momjian   #tutorial 
Removing Duplicate Rows in Postgres
What if you accidentally load data twice? A look at handling duplicate data and a resulting clean up.
Hans-Juergen Schoenig   #tutorial 
Upgrading a Postgres RDS Instance with Minimal Downtime
Database downtime is a big deal for any production database. Here’s some guidance for avoiding it if you’re running on AWS and want to upgrade with minimal impact.
John Gerhardt   #tutorial 
How Postgres's Advisory Locks Work
Locks in Postgres are often abstracted, and helpful for consistency in your database. At the same time if you’re running in a service oriented setup they can actually be a helpful tool to your application. This tour of locks and how you can use them will help you get started.
Vlad Mihalcea   #tutorial 
plgo: A Tool to Easily Create Postgres Extensions in Go
Vlado Magyar   #tools 
Bottled Water: Real-Time Integration of Postgres and Kafka
Stream change events from Postgres to a Kafka installation.
Confluent Inc.​   #tools 
Innovation in Enterprise Postgres & Open Source Data Management
Special track for developers/DBAs at Postgres Vision, Boston June 26-28. Save $200 with code PGWEEK by May 19.
Postgres Vision 2017    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.