Login Postgresql with specific database

$  psql -d db_name -U username

e.g. $  psql -d on_store_development -U postgres

then it will ask for password default is root or postgres. Or check your database.yml for a password that password you have to type here.