PostgreSQL
Using Separate Database Users for Migrations in Rails
In the past year I have done a lot of work with PostgreSQL (PG) and managing DDL (Data Definition Language) changes. This work has been focused on Java applications which use Flyway to manage migrations, which has less abstractions than Rails migrations. I have been thinking about how to apply some of the lessons I’ve learnt to Rails applications.
Index Name too Long in Rails
Today I ran into the issue with creating an Index in Rails (the database being PostgreSQL). The migration looked something like this:
How to Restore a PostgreSQL Backup from Heroku
Today I needed to make a backup of my PostgreSQL database on Heroku and restore it locally in order to do some testing. It turns out this is pretty easy.
Configuring Postgresql on OSX Lion
I ran into an issue today while trying to install PostgreSQL on OSX Lion. I followed the excellent documentation on this site – basically doing: