質問編集履歴

3

説明追加

2016/06/20 08:58

投稿

mikan1110
mikan1110

スコア15

test CHANGED
@@ -1 +1 @@
1
- syuu生postgresqlが繋がらなくなりました.PG::ConnectionBad: could not connect to server: Connection refused
1
+ postgresqlが繋がらなくなりました.PG::ConnectionBad: could not connect to server: Connection refused
test CHANGED
@@ -248,13 +248,39 @@
248
248
 
249
249
 
250
250
 
251
-
251
+ ```
252
+
253
+
254
+
252
-
255
+ ```
256
+
253
-
257
+ $ initdb /usr/local/var/postgres -E utf8
258
+
254
-
259
+ The files belonging to this database system will be owned by user "ponta".
260
+
255
-
261
+ This user must also own the server process.
262
+
263
+
264
+
256
-
265
+ The database cluster will be initialized with locale "ja_JP.UTF-8".
266
+
257
-
267
+ initdb: could not find suitable text search configuration for locale "ja_JP.UTF-8"
268
+
269
+ The default text search configuration will be set to "simple".
270
+
271
+
272
+
273
+ Data page checksums are disabled.
274
+
275
+
276
+
277
+ initdb: directory "/usr/local/var/postgres" exists but is not empty
278
+
279
+ If you want to create a new database system, either remove or empty
280
+
281
+ the directory "/usr/local/var/postgres" or run initdb
282
+
283
+ with an argument other than "/usr/local/var/postgres".
258
284
 
259
285
  ```
260
286
 

2

修正

2016/06/20 08:58

投稿

mikan1110
mikan1110

スコア15

test CHANGED
@@ -1 +1 @@
1
- postgresqlが繋がらなくなりました.PG::ConnectionBad: could not connect to server: Connection refused
1
+ syuu生postgresqlが繋がらなくなりました.PG::ConnectionBad: could not connect to server: Connection refused
test CHANGED
@@ -220,4 +220,44 @@
220
220
 
221
221
 
222
222
 
223
+ ```
224
+
225
+ /usr/local/var/postgres/server.log
226
+
227
+
228
+
229
+ postgres cannot access the server configuration file "/usr/local/var/postgres/postgresql.conf": No such file or directory
230
+
231
+ =>postgresql.logを手動で作成しました。
232
+
233
+
234
+
235
+
236
+
237
+
238
+
239
+ 作成した後のログ
240
+
241
+ =>
242
+
243
+ LOG: skipping missing configuration file "/usr/local/var/postgres/postgresql.auto.conf"
244
+
245
+ FATAL: data directory "/usr/local/var/postgres" has wrong ownership
246
+
247
+ HINT: The server must be started by the user that owns the data directory.
248
+
249
+
250
+
251
+
252
+
253
+
254
+
255
+
256
+
257
+
258
+
259
+ ```
260
+
261
+
262
+
223
263
  拙い質問となってしまい申し訳ありません、わかる方いましたらお手数ですが教えてくださいませ。

1

修正

2016/06/20 08:52

投稿

mikan1110
mikan1110

スコア15

test CHANGED
@@ -1 +1 @@
1
- postgresqlが繋がらなくなりました......PG::ConnectionBad: could not connect to server: Connection refused
1
+ postgresqlが繋がらなくなりました.PG::ConnectionBad: could not connect to server: Connection refused
test CHANGED
@@ -220,4 +220,4 @@
220
220
 
221
221
 
222
222
 
223
- 拙い質問となってしまい申し訳ありませんが助け欲しです..
223
+ 拙い質問となってしまい申し訳ありません、わかる方いましたらお手数です教えくださませ。