richardkmichael/travis-ci.github.com — Issue #1: Docs should be clearer about database setup.
Author: richardkmichael
Created: 2012-02-11 01:58:22+00:00
State: open

Discuss quoting and escaping in `.travis.yml`, consider `psql` usage:

```yaml
language: ruby
before_script:
# - "psql -h 127.0.0.1 -U postgres -c \"SELECT * FROM pg_user;\""
# - "psql -h 127.0.0.1 -U postgres -c \"CREATE ROLE rails PASSWORD 'rails' CREATEDB NOSUPERUSER NOCREATEROLE INHERIT LOGIN;\""
# - "psql -h 127.0.0.1 -U postgres -c \"CREATE DATABASE \\\"buy-my-beer-test\\\" OWNER rails;\""
- bundle exec rake db:create
- bundle exec rake db:schema:load
bundler_args: --without development
rvm:
- 1.9.3
```

Also, confirm that PostgresQL already has a user `rails` with create database permissions, and thus we can use `bundle exec rake db:create`, etc. ; and do *not* need to use `psql` (or `createdb`) to create the database.