Login as a user

psql postgres <name>;

eg: psql postgres prasanthabr

creating a db

=# create database <name of database>;

eg: Name of database can be the rails specified one for rails.