Tag: double-database - The Engine Room

October 18, 2014
By John Young

So You Want Another PostgreSQL Database? (Part 2)

Read Part 1

Automatic nightly base backups to Amazon S3 using WAL-E

In the first part of this series of posts, we set up streaming replication between a primary database and a replica database by shipping WAL files between them. While functional, it lacks the robustness and safety that a ... Read more.

September 20, 2014
By John Young

So You Want Another PostgreSQL Database? (Part 1)

Streaming replication with PostgreSQL 9.3 on Amazon EC2

They grow up so fast, don't they? It seems like just yesterday you were setting up your PostgreSQL server and tweaking settings you barely understood to try to get the most out of your database. But now, you've got a lot more data and your traffic continues to rise, and you've decided it's time your database had a few ... Read more.