@taketyan-manposted at 2024-04-04

Renderデプロイ時Postgresqlに接続できない

Q&A

解決したいこと

Ruby on Rails で制作したアプリをRenderにてデプロイしようとしているのですが、エラーメッセージが発生してしまっています。
お力添えよろしくお願いいたします

発生している問題・エラー

PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
==> Build failed 😞

該当するソースコード

database.yml

default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

development:
  <<: *default
  database: db/development.sqlite3

# 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: db/test.sqlite3

production:
  <<: *default
  adapter: postgresql
  encoding: unicode
  url: <%= ENV['DATABASE_URL'] %>

render.yaml

databases:
  - name: ToDo App db
    databaseName: to_do_app_production
    user: to_do_app_production_user
    region: singapore

services:
  - type: web
    name: ToDoApp
    env: ruby
    region: singapore
    buildCommand: "./bin/render-build.sh"
    startCommand: "bundle exec puma -C config/puma.rb"
    envVars:
      - key: <%= ENV['DATABASE_URL'] %>
        fromDatabase:
          name: render_app
          property: connectionString
      - key: <%= ENV['RAILS_MASTER_KEY'] %>
        sync: false