#224: Better Database Migrations in Postgres

.

Read this on the Web

Postgres Weekly Issue 224 — September 13, 2017

Better Database Migrations in Postgres Database migrations are a regular activity for any app, but there are a few things that can help make them run smoother on a production app. Here are a couple of tips to help manage migrations better. Craig Kerstiens Postgres's Workings in One Picture An interesting ‘infographic’ style image showing the various components of Postgres and how they stack together. Alexey Lesovsky Postgres Load Testing with pgreplay If you’re looking to simulate a production workload against a database once you make some changes, pgreplay can help. It parses Postgres logs and then replays them for you. Eric Worden JackDB: A modern database client for Postgres JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today. JackDB, Inc.​    #sponsored  Citus 7: Transactions, Framework Integration, and Postgres 10 Citus 7, which extends Postgres to easily shard your database, is here and introduces a number of new features including a foundation for distributed transactions, better framework integration, and Postgres 10 support. citusdata Using Atomic Transactions to Power an Idempotent API The start of a series of posts on building more robust (and data accurate) APIs by leaning on Postgres’s transactional features. Brandur Leach Speeding Up Creation of Postgres Replicas What can be done when the PostgreSQL replication process is painfully slow for bigger databases? Here are some tricks to make things easier. Kaarel Moppel Partitioning in Postgres 10 and Beyond Postgres 10 is coming with some native table partitioning. While this was possible before it took more manual work. Here's a few links with an early look at what’s coming. Bruce Momjian A Brief Reminder About Casting TIMESTAMPTZ ‘Timestamp with timezone’ is an awesome datatype but you need to take care to be explicit on your timezone lest you be stumped on data seeming off. Cristophe Pettus An Interview with Microsoft on Adding Postgres to Azure Microsoft’s Rohan Kumar on how they approach Postgres and the wider community. PostgresOpen SV 2017 PostgreSQL Automatic Failover 2.2 Released An agent for the Pacemaker high availability cluster resource manager to let it keep tabs on Postgres instances. Mael Rimbault and Jehan-Guillaume de Rorthais   #tools  pglite: A Tiny (Shell) Script to Manage Ephemeral Postgres Databases Jason Dusek   #tools  Say hello to PostgreSQL’s perfect match Start a free trial to see how SelectStar’s comprehensive monitoring can compliment your Postgres environment. SelectStar    #sponsored  hkpg: Automated Archiving of Heroku Postgres Backups to S3 Simon Taranto   #code  pqstream: Turn Your Postgres Database Into an Event Stream This could be used to get going with event sourcing without having to install any new software. Travis Cline   #code  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK