Tuning your PostgreSQL servers on Amazon EC2
It will probably come as no surprise that the settings that are best for your PostgreSQL cluster are heavily dependent on your data and how you're using it. ... Read more.
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.
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.