为什么我的Rails db:create无法运行?

4

我按照类似的文档进行了操作,但是我不确定它们是否适用于我的情况,尤其是在我使用Rails 5时。因此,我创建了一个Rails API骨架,并尝试运行以下命令:

rails db:create

我遇到了以下错误:

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!

我已检查本地是否正在运行postgresql:

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.

过去的文档提到了config/database.yml文件,这是我的文件内容:
# 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]
5个回答

1
对于那些在2023年偶然看到这个答案的人来说,当从Microsoft Store安装Ubuntu时,Windows 10似乎默认使用wsl 1。我通过执行db:create使其正常工作。
wsl --set-version Ubuntu-22.04 2

从PowerShell中运行(我之前运行了wsl --shutdown,但我不确定是否需要)

非常感谢,我在使用Windows 10中的WSL创建Postgres数据库时遇到了很多困难,但是将WSL版本设置为WSL 2解决了我的问题。 - undefined

1

我猜问题是因为你在database.yml中注释了主机和端口。

请尝试使用以下示例配置来检查是否有效。

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

这篇帖子中的答案解决了我的问题:https://dev59.com/NGMm5IYBdhLWcg3wKsgj - Daniel
太棒了。祝你有美好的一天! :) - RamPrasad Reddy

0

前往你的config/database.yml文件,获取数据库名称。在我的情况下,数据库名称是DevcampPortfolio_development。

database: DevcampPortfolio_development

接下来,打开终端并输入:

psql -c "create database DevcampPortfolio_development owner=ubuntu"

然后,继续您的正常工作


0

好的,首先进入您的应用程序目录并输入

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

然后正常创建您的数据库


0

你可以试试这个...

首先,你需要检查你的 gem 版本...

gem 'pg'

然后您可以检查您的pg 用户名密码

如果您忘记了用户名密码,不要担心 :(。

您可以更改..

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

现在可以更改你的 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

如果你遇到了其他错误,请告诉我。


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接