質問編集履歴
1
a
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -103,3 +103,123 @@
|
|
|
103
103
|
database: db/production.sqlite3
|
|
104
104
|
|
|
105
105
|
```
|
|
106
|
+
|
|
107
|
+
|
|
108
|
+
|
|
109
|
+
# 追記
|
|
110
|
+
|
|
111
|
+
ご回答いただき、下記3つの対応を行いましたが未だに上手くいきません。。
|
|
112
|
+
|
|
113
|
+
①PostgreSQLのインストールを実施
|
|
114
|
+
|
|
115
|
+
②database.ymlを以下のように修正
|
|
116
|
+
|
|
117
|
+
```databaseyml
|
|
118
|
+
|
|
119
|
+
# SQLite version 3.x
|
|
120
|
+
|
|
121
|
+
# gem install sqlite3
|
|
122
|
+
|
|
123
|
+
#
|
|
124
|
+
|
|
125
|
+
# Ensure the SQLite 3 gem is defined in your Gemfile
|
|
126
|
+
|
|
127
|
+
# gem 'sqlite3'
|
|
128
|
+
|
|
129
|
+
#
|
|
130
|
+
|
|
131
|
+
default: &default
|
|
132
|
+
|
|
133
|
+
adapter: postgresql
|
|
134
|
+
|
|
135
|
+
pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
|
|
136
|
+
|
|
137
|
+
timeout: 5000
|
|
138
|
+
|
|
139
|
+
|
|
140
|
+
|
|
141
|
+
development:
|
|
142
|
+
|
|
143
|
+
<<: *default
|
|
144
|
+
|
|
145
|
+
database: appname_development
|
|
146
|
+
|
|
147
|
+
|
|
148
|
+
|
|
149
|
+
# Warning: The database defined as "test" will be erased and
|
|
150
|
+
|
|
151
|
+
# re-generated from your development database when you run "rake".
|
|
152
|
+
|
|
153
|
+
# Do not set this db to the same as development or production.
|
|
154
|
+
|
|
155
|
+
test:
|
|
156
|
+
|
|
157
|
+
<<: *default
|
|
158
|
+
|
|
159
|
+
database: appname_test
|
|
160
|
+
|
|
161
|
+
|
|
162
|
+
|
|
163
|
+
production:
|
|
164
|
+
|
|
165
|
+
<<: *default
|
|
166
|
+
|
|
167
|
+
database: appname_production
|
|
168
|
+
|
|
169
|
+
username: appname
|
|
170
|
+
|
|
171
|
+
password: <%= ENV['APPNAME_DATABASE_PASSWORD'] %>
|
|
172
|
+
|
|
173
|
+
```
|
|
174
|
+
|
|
175
|
+
・PostgreSQL\12\data\pg_hba.conf」を以下のように修正
|
|
176
|
+
|
|
177
|
+
|
|
178
|
+
|
|
179
|
+
```before
|
|
180
|
+
|
|
181
|
+
# IPv4 local connections:
|
|
182
|
+
|
|
183
|
+
host all all 127.0.0.1/32 md5
|
|
184
|
+
|
|
185
|
+
# IPv6 local connections:
|
|
186
|
+
|
|
187
|
+
host all all ::1/128 md5
|
|
188
|
+
|
|
189
|
+
# Allow replication connections from localhost, by a user with the
|
|
190
|
+
|
|
191
|
+
# replication privilege.
|
|
192
|
+
|
|
193
|
+
host replication all 127.0.0.1/32 md5
|
|
194
|
+
|
|
195
|
+
host replication all ::1/128 md5
|
|
196
|
+
|
|
197
|
+
```
|
|
198
|
+
|
|
199
|
+
```after
|
|
200
|
+
|
|
201
|
+
# IPv4 local connections:
|
|
202
|
+
|
|
203
|
+
host all all 127.0.0.1/32 trust
|
|
204
|
+
|
|
205
|
+
# IPv6 local connections:
|
|
206
|
+
|
|
207
|
+
host all all ::1/128 trust
|
|
208
|
+
|
|
209
|
+
# Allow replication connections from localhost, by a user with the
|
|
210
|
+
|
|
211
|
+
# replication privilege.
|
|
212
|
+
|
|
213
|
+
host replication all 127.0.0.1/32 trust
|
|
214
|
+
|
|
215
|
+
host replication all ::1/128 trust
|
|
216
|
+
|
|
217
|
+
```
|
|
218
|
+
|
|
219
|
+
上記の対応を行い、再実施したところ、以下のエラーが発生しました。
|
|
220
|
+
|
|
221
|
+
```ConnectionBad
|
|
222
|
+
|
|
223
|
+
fe_sendauth: no password supplied
|
|
224
|
+
|
|
225
|
+
```
|