Unable to create database with rake db:create command

Question

I had postgresql service running but when I run rake db:create it abort the rake and throws error

ActiveRecord::NoDatabaseError: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database “chat_development" does not exist

In my database.yml I have

development:
  <<: *default
  database: chat_development

By running the rake command it should create the database but it didn't. I did a lot research and try out the solutions given but nothing work. I did check on this discussion here but when I run rm /usr/local/var/postgres/postmaster.pid it throws error

rm: /usr/local/var/postgres/postmaster.pid: No such file or directory

If I run command ps auxwww | grep postgres it will show /opt/homebrew/opt/postgresql/bin/postgres -D /opt/homebrew/var/postgres

If I remember correctly I had issue with the postgres installation when I was getting started (about 4 weeks ago) and did install using Postgres.app, then I had also installed with brew install postgresql (since I am using mac). I am not sure if there are conflict due to multiple installation.

But just now I uninstalled postgres.app and also ran gem uninstall pg and re-install using command gem install pg -- --with-pg-config=/usr/local/bin/pg_config (ref here)

The issue is still there. I don't know what to do anymore. Glad if someone can help. Thank you!

Ben Garcia · Accepted Answer · 2022-04-25 08:59:48Z

5

Had this issue and never quite figured out why rails was doing this, but below should fix it.

in terminal psql template1
CREATE USER <username from config/database.yml if specified> with password '<password from config/database.yml if specified>';
ALTER USER <username ...> WITH SUPERUSER;
CREATE DATABASE chat_development WITH OWNER = '<username ...>';
CREATE DATABASE chat_test WITH OWNER = '<username ...>';

you don't need step 2/3, or the WITH OWNER = '<username>'; unless you specify a user/password in config/database.yml.

Some common mistakes, pay close attention to where I have put single quotes, and don't forget the semi-colons!

answered Apr 25, 2022 at 8:59

Ben Garcia

3862 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eaten Taik Over a year ago

Hi thank you for the solution. I can create the database with these steps.

Yusuf N · Accepted Answer · 2022-04-25 08:23:36Z

0

In order to solve this problem, you need progress this in step-by-step fashion.

Run the postgresql server
Test creating a sample database using a simple client like psql, which should show whether the server is running and you have the right socket/port connection and user credential with authorization
Check your application configuration to see if you have the correct connection and user credential setup

answered Apr 25, 2022 at 8:23

Yusuf N

3411 silver badge2 bronze badges

Collectives™ on Stack Overflow

Unable to create database with rake db:create command

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related