Hello,
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" (127.0.0.1) 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
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?
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!
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.
Accepted Answer
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. :/
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
