1

Most important thing, I'm sorry, but I'm not native English speaker.

What I can't
After I deployed my app via "Render.com" (Luckily, it has been a success!), I thought keep developing in local env, but I can't connect my DB.

Error Description
I wanted to test with Rspec, but I got an error so I tried "rails db:reset" to see if it would work.

rails aborted!
ActiveRecord::ConnectionNotEstablished: could not translate host name "xxxxxxxxxxxx" to address: Name or service not known

What I want to do
I would like to eliminate this error so that I can continue to develop properly and locally.

Worry
I am concerned that it may have some effect on the deployed apps. If anyone knows, please advise.

Environment

Ruby 3.1.2
Rails 7.0.4

Addendum
database.yml

# PostgreSQL. Versions 9.3 and up are supported.
#
# Install the pg driver:
#   gem install pg
# On macOS with Homebrew:
#   gem install pg -- --with-pg-config=/usr/local/bin/pg_config
# On macOS 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
  # https://guides.rubyonrails.org/configuring.html#database-pooling
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  database: k_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 running Rails.
  #username: k

  # 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: k_test

# As with config/credentials.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 or a full connection URL as an environment
# variable when you boot the app. For example:
#
#   DATABASE_URL="postgres://myuser:mypass@localhost/somedatabase"
#
# If the connection URL is provided in the special DATABASE_URL environment
# variable, Rails will automatically merge its configuration values on top of
# the values provided in this file. Alternatively, you can specify a connection
# URL environment variable explicitly:
#
#   production:
#     url: <%= ENV["MY_APP_DATABASE_URL"] %>
#
# Read https://guides.rubyonrails.org/configuring.html#configuring-a-database
# for a full overview on how database connection configuration can be specified.
#
production:
  <<: *default
  database: k_production
  username: <%= ENV["K_DATABASE_USERNAME"] %>
  password: <%= ENV["K_DATABASE_PASSWORD"] %>
6
  • Could you add your database config to the question, please? Commented Dec 13, 2022 at 14:09
  • 1
    Your English is fine, however, this is thin on details as to how we might reproduce this problem. That kind of error usually means a DNS issue, or possibly a configuration issue where the DNS name used is incorrect. Check your config/database.yml. Make sure you're not using your server's configuration locally. This is why development and production are different. Commented Dec 13, 2022 at 14:15
  • Mr. Strukov Thank you for your comment. I add "database.yml". Commented Dec 13, 2022 at 14:27
  • Mr. tadman Thank you for your comment. I add "database.yml". I searched my error message so I understand what you tole me, but I don't know how to write code for development. Commented Dec 13, 2022 at 14:32
  • Did you happen to set ENV['DATABASE_URL'] locally? Commented Dec 13, 2022 at 17:44

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.