By m73mitchell
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
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!
Got it to work by reploying the app, which I guess restarted all the related processes. Thanks for your help.
Can you connect to the postgres server from the production webserver? <br> <br>Try “telnet 178.XXX.XXX.XXX 5432” - can it connect or does it timeout?
What’s the output of “nestat -plutn | grep 5432” on the postgres server? Postgres is probably listening locally.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.