I have followed this really helpful tutorial:
http://blog.willj.net/2011/05/31/setting-up-postgresql-for-ruby-on-rails-development-on-os-x/
I would really like to run rails new myapp and have the postgres db set up automatically. Is there any way I can do that using a Rails application template or something similar?
On a unix based system:
sudo -u postgres createuser -d -R -P APPNAME
sudo -u postgres createdb -O APPNAME APPNAME
You can create a script and put it somewhere in your $PATH if you can't remember.
createuser -d -R -P will create a user that can create a db (-d), can't create role (-R), and prompt for password(-P) postgresql.org/docs/9.1/static/app-createuser.html createdb -O will create a db with the specified owner (-O) postgresql.org/docs/9.1/static/app-createdb.htmlActually you don't need to create a new user each time you create a new rails app.
All you have to do is create the new application and change the username in your database.yml
development:
adapter: postgresql
encoding: unicode
database: newapp_development
pool: 5
username: #your username
password:
...
than just:
rake db:create:all
'config/database.yml', %Q{stuff for database.yml here} However I need to get the name of the app into the template.rb file. Is that possible?