Problem with accessing postgresql in one-click rails droplet


I created new rails application using one-click installation. It gave me two users: root and rails.

When I try to run migrations on my rails user, it says:

RAILS_ENV=production rails db:migrate
=>rake aborted!
PG::ConnectionBad: could not connect to server: Connection refused
	Is the server running on host "localhost" ( and accepting
	TCP/IP connections on port 5432?

I tried to login to root, and run: sudo systemctl postgresql start but even if there is no errors returned, calling psql still returns problem with connectint to the server:

psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I did not change any config yet, it’s raw installation. The weird thing is that the application actually works - so it is somehow connected to the postgres database.

How can I solve this problem?


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

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.

When I deployed the Ruby on Rails one click application these were all of the commands I used to get to the psql command line:

root@ruby-rails:~# su - rails rails@ruby-rails:~$ psql

After switching to the rails user and ran the psql command I could access the psql cli. If that’s not working for you it may be a corrupted install. :/