Unlike SQLite, PostgreSQL does not store databases in separate files.
After creating your database , try something like this:
DataMapper.setup :default, {
:adapter => 'postgres',
:host => 'localhost',
:database => 'your-database-name',
:user => 'postgres',
}
PostgreSQL / :password.
:
DataMapper.setup(:default, 'postgres://user:password@hostname/database')