title: pg_restore asking for password for database when there isn't one
body: <p>I'm setting up a Rails app on a fresh Ubuntu installation and created the Postgres databases using rake db:create:all. In databases.yml, the password field for all databases is left blank. I'm trying to do a pg_restore of a dump I captured from the app's production deployment, but I keep being prompted for a password. I have a feeling this is something to do with the settings in the pg_hba.conf file, but I can't remember how I had them set in my previous Ubuntu installation. How do I get Postgres to trust pg_restore for local connections? Or is there something different causing this issue?</p>