Hi,
I am trying to create a heroku app with rails using my xtuple postgresql database. It is working locally. I am able to do sql queries and have it return as json. However, when I push it to heroku, it stops functioning. I included the database credentials(host, port, database, user, password) in my database.yml. I have checked the server configuration(pg_hba.conf and postgresql.conf) and it appears that all ip have already been grant access(host all all 0.0.0.0/0 md5 and listen_addresses ‘*’, respectively). I have also add in the variable DATABASE_URL=postgres://Username:Password@IPAddress:Port/DatabaseName to heroku. If you can let me know what I should do to make it work, that would be great. Please let me know if any questions.
Thanks!
Zhu