如何开始在rails应用程序中使用Postgresql数据库？

Question

我花了几个小时在网上寻找这方面的解决方案。Postgresql安装指南没有帮助，因为我不熟悉只与rails交互并以这种方式处理数据库。

我通过以下教程制作了几个简单的rails应用程序，现在还在学习rails。我使用的是Windows 10，我已经将其中的一些部署到Heroku，为此我不得不使用pg宝石，因为Heroku不使用sqlite3。但是我在几个地方读到需要在本地安装postgresql。所以我安装了它，我想，但现在我迷路了。我有一个名为pgAdmin4的软件，现在我完全不知道如何通过rails使用postgresql。我使用以下命令启动了一个新应用程序来测试它：

rails new postgresapp --database=postgresql

这给了我一个使用postgresql的新应用程序的基本起点。当我试图连接到localhost3000时，第一个错误是：

PG::ConnectionBad
fe_sendauth: no password supplied

Extracted source (around line #56):

    ### Convenience alias for PG::Connection.new.
    def self::connect( *args )
        return PG::Connection.new( *args )
    end

请记住，我不确定安装是否成功。我完成了安装过程，输入了密码和所有信息，所以我假设它确实安装在某个地方。

而且，pgAdmin上没有显示服务器，所以我添加了一个名为localhost的服务器。我不知道这是不是正确的做法。

创业板档案：

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.6'
# Use postgresql as the database for Active Record
gem 'pg', '~> 0.18'
# Use Puma as the app server
gem 'puma', '~> 3.0'
# Use SCSS for stylesheets
gem 'sass-rails', '~> 5.0'
# Use Uglifier as compressor for JavaScript assets
gem 'uglifier', '>= 1.3.0'
# Use CoffeeScript for .coffee assets and views
gem 'coffee-rails', '~> 4.2'
# See https://github.com/rails/execjs#readme for more supported runtimes
# gem 'therubyracer', platforms: :ruby

# Use jquery as the JavaScript library
gem 'jquery-rails'
# Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
gem 'turbolinks', '~> 5'
# 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

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
  # Access an IRB console on exception pages or by using <%= console %> anywhere in the code.
  gem 'web-console', '>= 3.3.0'
end

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

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: postgresapp_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: postgresapp

  # 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: postgresapp_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: postgresapp_production
  username: postgresapp
  password: post#<%= ENV['POSTGRESAPP_DATABASE_PASSWORD'] %>

Answer 1

当您检查database.yml文件中的内容时，需要配置用户和密码。

您的密码作为空白值。

我建议使用密码创建一个postgreSql用户并使用这些凭据。

您需要psql从终端访问postgreSql，以创建具有权限的新用户。

其中一个链接，你可以在网上找到更多关于这个的信息。

但是你的问题是用户和他的密码

在修复用户和密码问题后，您将需要创建名称来自database.yml的DB。

在您的database.yml数据库中，名称是postgresapp_development。你会创造它的。使用安装和创建DB时定义的用户和密码，为windows找到一个连接到postgreSql的客户端。

检查这是否访问postgresSql服务器