Postgres Weekly Issue 8
May 1, 2013
Postgres: the transaction system and how it works
Want to get an idea of how transactions actually work inside Postgres? Hidden in the Postgres source is this great readme on how transactions are actually handled.
postgression: A PostgreSQL Database for Every Test Case
If you're building your application and have good testing processes you may not want to have to deal with setting up Postgres locally to test. Postgression makes it easy for you to immediately a database within the cloud and use for testing, then throw it away. As its in the cloud you may have some latency when developing locally, but this setup works great for CI.
From our sponsor
Heroku Postgres - Fully managed Postgres on EC2
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.

Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
Other links
Secure deployment of PostgreSQL functions
While there is often debate about whether to put functionality inside your database in the form of functions sometimes its inevitable. When you do ensuring you're not overwriting others functionality becomes a necessity. Here's how you can securely deploy function changes and diff them after within your database.
Introduction to PostgreSQL Arrays, Basic Concepts and Normalization Considerations
Securing PostgreSQL using hostssl cert clientcert=1
You can't be too safe when it comes to your data; unknown to many Postgres has great support for using SSL certs as authentication. Here's a great guide for getting setup with them.
Rails 4 UUID primary keys with PostgreSQL
If building a distributed app sequentially incrementing ids start to fail you. A simple change thats great to do from the start of any project is to use UUID. You can easily swap our your primary key in rails to use the Postgres UUID datatype.
Heroku Postgres - GIS Support Now Available
Async database access with PostgreSQL, Play, Scala and Heroku