Why is my rails db:create not working?

Question

I have followed similar documentation here, but admittedly I am not sure if they apply in this case, especially when I am working in Rails 5. So I created an Rails API skeleton and now I tried to run:

rails db:create

and I get this error:

could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "database"=>"freelance_camp_documents_development"}
rails aborted!

I did check to see if postgresql is running locally:

ldco2016@DCortes-MacBook-Pro-3 ~/Projects/freelance_camp_documents (master)$ brew services start postgresql
Service `postgresql` already started, use `brew services restart postgresql` to restart.

The past documentation referenced the config/database.yml file, here is mine:

# PostgreSQL. Versions 9.1 and up are supported.
#
# Install the pg driver:
#   gem install pg
# On OS X with Homebrew:
#   gem install pg -- --with-pg-config=/usr/local/bin/pg_config
# On OS X with MacPorts:
#   gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
# On Windows:
#   gem install pg
#       Choose the win32 build.
#       Install PostgreSQL and put its /bin directory on your path.
#
# Configure Using Gemfile
# gem 'pg'
#
default: &default
  adapter: postgresql
  encoding: unicode
  # For details on connection pooling, see rails configuration guide
  # http://guides.rubyonrails.org/configuring.html#database-pooling
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  database: freelance_camp_documents_development

  # The specified database role being used to connect to postgres.
  # To create additional roles in postgres see `$ createuser --help`.
  # When left blank, postgres will use the default role. This is
  # the same name as the operating system user that initialized the database.
  #username: freelance_camp_documents

  # The password associated with the postgres role (username).
  #password:

  # Connect on a TCP socket. Omitted by default since the client uses a
  # domain socket that doesn't need configuration. Windows does not have
  # domain sockets, so uncomment these lines.
  #host: localhost

  # The TCP port the server listens on. Defaults to 5432.
  # If your server runs on a different port number, change accordingly.
  #port: 5432

  # Schema search path. The server defaults to $user,public
  #schema_search_path: myapp,sharedapp,public

  # Minimum log levels, in increasing order:
  #   debug5, debug4, debug3, debug2, debug1,
  #   log, notice, warning, error, fatal, and panic
  # Defaults to warning.
  #min_messages: notice

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default
  database: freelance_camp_documents_test

# As with config/secrets.yml, you never want to store sensitive information,
# like your database password, in your source code. If your source code is
# ever seen by anyone, they now have access to your database.
#
# Instead, provide the password as a unix environment variable when you boot
# the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database
# for a full rundown on how to provide these environment variables in a
# production deployment.
#
# On Heroku and other platform providers, you may have a full connection URL
# available as an environment variable. For example:
#
#   DATABASE_URL="postgres://myuser:mypass@localhost/somedatabase"
#
# You can use this database configuration with:
#
#   production:
#     url: <%= ENV['DATABASE_URL'] %>
#
production:
  <<: *default
  database: freelance_camp_documents_production
  username: freelance_camp_documents
  password: <%= ENV['FREELANCE_CAMP_DOCUMENTS_DATABASE_PASSWORD'] %>

Here is the gemfile:

source 'https://rubygems.org'

git_source(:github) do |repo_name|
  repo_name = "#{repo_name}/#{repo_name}" unless repo_name.include?("/")
  "https://github.com/#{repo_name}.git"
end


# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
gem 'rails', '~> 5.0.1'
# Use postgresql as the database for Active Record
gem 'pg', '~> 0.18'
# Use Puma as the app server
gem 'puma', '~> 3.0'
# Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
# gem 'jbuilder', '~> 2.5'
# Use Redis adapter to run Action Cable in production
# gem 'redis', '~> 3.0'
# Use ActiveModel has_secure_password
# gem 'bcrypt', '~> 3.1.7'

# Use Capistrano for deployment
# gem 'capistrano-rails', group: :development

# Use Rack CORS for handling Cross-Origin Resource Sharing (CORS), making cross-origin AJAX possible
# gem 'rack-cors'

group :development, :test do
  # Call 'byebug' anywhere in the code to stop execution and get a debugger console
  gem 'byebug', platform: :mri
end

group :development do
  gem 'listen', '~> 3.0.5'
  # Spring speeds up development by keeping your application running in the background. Read more: https://github.com/rails/spring
  gem 'spring'
  gem 'spring-watcher-listen', '~> 2.0.0'
end

# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]

score 1 · Answer 1 · answered Jan 11 '17 at 04:24

1

I guess the problem is because you have your host and port commented in your database.yml.

Please try using the below sample configuration to check if it works.

default: &default
  adapter: postgresql
  encoding: unicode
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  database: freelance_camp_documents_development
  username: postgres // default username. Please change if you created a new user for your app
  password: postgres // default password
  host: localhost
  port: 5432

answered Jan 11 '17 at 04:24

RamPrasad Reddy

115
1
5

The answer in this post is what solved it for me: https://stackoverflow.com/questions/17822974/postgres-fatal-database-files-are-incompatible-with-server – Daniel Jan 11 '17 at 05:24
Awesome. Have a nice day!! :) – RamPrasad Reddy Jan 11 '17 at 06:09

score 0 · Accepted Answer · answered Jan 11 '17 at 04:33

You just try this..

first of all you just check your gem versions..

gem 'pg'

Then you can check your pg username and password..

If you forgot your username and password don't worry :(..

You can change..

$ sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';"
//OR
$ sudo passwd postgres

Now can change your database.yml

development:
  encoding: unicode
  username: postgres
  password: postgres
  pool: 20
  timeout: 5000
  wait_timeout: 10
  min_messages: warning
  adapter: postgresql
  host: localhost
  database: auction_dev
  port: 5432

If you got any other error let me know..

score 0 · Answer 3 · answered Oct 16 '18 at 15:20

go to your config/database.yml and get the database name in my case the database name is DevcampPortfolio_development

database: DevcampPortfolio_development

next, go to the terminal and put:

psql -c "create database DevcampPortfolio_development owner=ubuntu"

then, continue your work normally

score 0 · Answer 4 · answered Oct 16 '18 at 16:55

ok so, first go to your application directory and write

psql

UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';

DROP DATABASE template1;

CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';

UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';

\c template1

VACUUM FREEZE;

\q

and create then your database normally

parluc · Answer 5 · 2023-08-09T01:17:56.527

0

For those stumbling upon this answer in 2023, Windows 10 seems to use wsl 1 by default when installing Ubuntu from the Microsoft Store. I got db:create working by executing

wsl --set-version Ubuntu-22.04 2

from PowerShell. (I previously ran wsl --shutdown, but I'm not sure if that's needed)

edited Aug 09 '23 at 01:17

answered Aug 09 '23 at 01:08

parluc

1
2

Why is my rails db:create not working?

5 Answers5