sudo -u postgres psql
postgres=# create role username login;
postgres=# create database databasename owner username;
然后修改/etc/postgresql/8.4/main/pg_hba.conf,在all/all前加一行
local databasename username trust
对应数据库url配置: dialect+driver://username@/database
host databasename username 127.0.0.1/32 trust
对应数据库url配置:dialect+driver://username@host:port/database