So I’ve set up a PostgreSQL database on my cloud9 IDE account according to this: https://github.com/Aerogami/guides/wiki/Cloud9-workspace-setup-with-Rails-and-Postgresql
This is what my database.yml file looks like:
username: <%= ENV[‘USERNAME’] %>
password: <%= ENV[‘PASSWORD’] %>
host: <%= ENV[‘IP’] %>
I then created a user model, migrated it, and reloaded my app. However when I loaded the app on the local server using this command: rails server -b $IP -p $PORT on the cloud9 command line, I get the following error message: fe_sendauth: no password supplied error. I do not understand what is going wrong since I have created a superuser with a password and have included those in my database.yml file. The only thing I found was that this error can be fixed by changing the pg_hba.conf file to trust the local server. However I thought the whole point of creating a superuser and password in the Cloud9 IDE was so that you don’t have to do this. Also Cloud9 doesn’t give you access to the pg_hba.conf file.