Question

connecting to database on a different server

I deployed a sample Rails app to a remote server with postgres hosted on the same server. The database.yml file was like this.

production: adapter: postgresql encoding: unicode database: remotepg_production pool: 5 host: localhost username: mrmann password: secret Everything worked fine. I then went into the database.yml file and replaced host: localhost with the ip address of a postgres database on another server host: 178.XXX.XXX like this

production: adapter: postgresql encoding: unicode database: remotepg_production pool: 5 host: 178.XXX.XXX.XXX #ip address of server with other postgres database username: mrmann password: secret When I restarted postgres on the server with the Rails app, the sample application now gave me the ‘something went wrong’ page for Rails.

The username and the password for the username are the same on both dbs. Can you suggest what the problem might be? Thanks


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Got it to work by reploying the app, which I guess restarted all the related processes. Thanks for your help.

That’s weird. Did you save the file? Make sure you restart any related processes as the code/config might be cached in one of them.

I removed that line from pg_hba.conf. Postgres restarts now on the server with the database I want to connect to. The rails app, however, is connected to the database on its own server, even though the host in the database.yml file is set to the ip address of server that has the postgres database I want to connect to i.e. the rails app is not connecting to database on the other server. <br> <br>