--- title: "#224: Better Database Migrations in Postgres" publication: "Postgres Weekly" issue: 224 published_at: "2017-09-13" canonical_url: "https://postgresweekly.com/issues/224" --- Postgres Weekly 224 . [Read this on the Web](http://postgresweekly.com/issues/224) [Postgres Weekly](http://postgresweekly.com) Issue 224 — September 13, 2017 [Better Database Migrations in Postgres](http://www.craigkerstiens.com/2017/09/10/better-postgres-migrations/?utm_source=postgresweekly&utm_medium=email)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](http://blog.postgresql-consulting.com/2017/09/postgresql-workings-in-one-picture.html?utm_source=postgresweekly&utm_medium=email)An interesting ‘infographic’ style image showing the various components of Postgres and how they stack together. Alexey Lesovsky [Postgres Load Testing with pgreplay](https://www.commandprompt.com/blog/postgres-load-testing-pgreplay/?utm_source=postgresweekly&utm_medium=email)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](https://www.jackdb.com/)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[![\](https://copm.s3.amazonaws.com/14f5a240.png)](https://www.jackdb.com/) [Citus 7: Transactions, Framework Integration, and Postgres 10](https://www.citusdata.com/blog/2017/09/07/citus-7-distributed-transactions-frameworks-and-pg10/?utm_source=postgresweekly&utm_medium=email)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](https://brandur.org/http-transactions?utm_source=postgresweekly&utm_medium=email)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](http://www.cybertec.at/speeding-up-creation-of-postgres-replicas/?utm_source=postgresweekly&utm_medium=email)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](https://momjian.us/main/blogs/pgblog/2017.html?utm_source=postgresweekly&utm_medium=email#September_11_2017)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](http://thebuild.com/blog/2017/09/05/a-brief-reminder-about-casting-timestamptz/?utm_source=postgresweekly&utm_medium=email)‘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](https://2017.postgresopen.org/blog-microsoft/?utm_source=postgresweekly&utm_medium=email)Microsoft’s Rohan Kumar on how they approach Postgres and the wider community. PostgresOpen SV 2017 [PostgreSQL Automatic Failover 2.2 Released](http://dalibo.github.io/PAF/?utm_source=postgresweekly&utm_medium=email)An agent for the [Pacemaker](https://github.com/ClusterLabs/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](https://github.com/solidsnack/pglite?utm_source=postgresweekly&utm_medium=email) Jason Dusek#tools [Say hello to PostgreSQL’s perfect match](https://selectstar.io/blog/3-strategies-to-improve-postgresql-performance-schemas/?utm_source=sponsored&utm_medium=email&utm_campaign=09+13+2017+Postgres+Weekly)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](https://github.com/srt32/hkpg/?utm_source=postgresweekly&utm_medium=email) Simon Taranto#code [pqstream: Turn Your Postgres Database Into an Event Stream](https://github.com/tmc/pqstream?utm_source=postgresweekly&utm_medium=email)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](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/224) [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