cheat sheets.

Here's what you wrote, so it isn't lost in the void:
Rails related postgres gotchas
==============================

silence CREATE TABLE in tests
-----------------------------
  In database.yml:
     min_messages: warning # silence CREATE TABLE messages in postgres

silence postgres system table access in logs
--------------------------------------------
see
http://railsonpostgresql.com/2010/10/06/reducing-log-output-from-the-rails-postgr
sql-connection-adapter
    gem 'silent-postgres'

postgres holds onto conections:
--------------------------------
  see# https://gist.github.com/1157737



Need structure dump/load (triggers, full-text search)?
=====================================================

username is required for db_dump
--------------------------------
  In database.yml:
      username: <%= `whoami` %> # needed for sq_dump

update rake tasks for structure dump/load:
------------------------------------------
  see# https://gist.github.com/1157737

Need help adding a user?
    $ sudo su postgres
    $ createuser `whoami`