postgresql - Wiki.js 未运行。数据库连接错误
问题描述
Windows Enterprise 2016 LTSB 版本 1607。使用 PostgreSQL 安装了 Wiki.js。之前安装了 Node.js (v12.16.2)。
使用 Powershell 进入wiki.js安装过程的第 8 步:
node server
我收到此错误:
PS C:\wiki> node server
Loading configuration from C:\wiki\config.yml... OK
2021-01-03T23:06:14.299Z [MASTER] info: =======================================
2021-01-03T23:06:14.300Z [MASTER] info: = Wiki.js 2.5.170 =====================
2021-01-03T23:06:14.301Z [MASTER] info: =======================================
2021-01-03T23:06:14.301Z [MASTER] info: Initializing...
2021-01-03T23:06:14.688Z [MASTER] info: Using database driver pg for postgres [ OK ]
2021-01-03T23:06:14.690Z [MASTER] info: Connecting to database...
2021-01-03T23:06:15.698Z [MASTER] error: Database Connection Error: ECONNREFUSED 127.0.0.1:5432
2021-01-03T23:06:15.698Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2021-01-03T23:06:18.700Z [MASTER] info: Connecting to database...
2021-01-03T23:06:19.703Z [MASTER] error: Database Connection Error: ECONNREFUSED 127.0.0.1:5432
2021-01-03T23:06:19.703Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]
... (you get the point)
2021-01-03T23:06:51.728Z [MASTER] error: Database Connection Error: ECONNREFUSED 127.0.0.1:5432
2021-01-03T23:06:51.729Z [MASTER] warn: Will retry in 3 seconds... [Attempt 10 of 10]
2021-01-03T23:06:54.730Z [MASTER] info: Connecting to database...
2021-01-03T23:06:55.733Z [MASTER] error: Database Initialization Error: connect ECONNREFUSED 127.0.0.1:5432
我意识到我忘了创建一个 PostgreSQL,所以我使用 pgAdmin4.28 创建了一个“wiki”数据库。错误现在更改为:
PS C:\wiki> node server
Loading configuration from C:\wiki\config.yml... OK
2021-01-04T00:27:21.979Z [MASTER] info: =======================================
2021-01-04T00:27:21.980Z [MASTER] info: = Wiki.js 2.5.170 =====================
2021-01-04T00:27:21.981Z [MASTER] info: =======================================
2021-01-04T00:27:21.982Z [MASTER] info: Initializing...
2021-01-04T00:27:22.363Z [MASTER] info: Using database driver pg for postgres [ OK ]
2021-01-04T00:27:22.365Z [MASTER] info: Connecting to database...
2021-01-04T00:27:22.428Z [MASTER] error: Database Connection Error: 28P01 undefined:undefined
2021-01-04T00:27:22.429Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2021-01-04T00:27:25.431Z [MASTER] info: Connecting to database...
2021-01-04T00:27:25.501Z [MASTER] error: Database Connection Error: 28P01 undefined:undefined
2021-01-04T00:27:25.501Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]
2021-01-04T00:27:28.503Z [MASTER] info: Connecting to database...
2021-01-04T00:27:28.545Z [MASTER] error: Database Connection Error: 28P01 undefined:undefined
2021-01-04T00:27:28.546Z [MASTER] warn: Will retry in 3 seconds... [Attempt 3 of 10]
请发送帮助!我感谢所有评论。谢谢!
解决方案
我对 postgres 和 wiki.js 有类似的问题。解决方案是在运行之前在 postgres 中手动创建数据库node server
:
CREATE DATABASE wiki
希望这可以节省我花费在解决这个问题上的时间。
推荐阅读
- c# - 检查序列是否是另一个序列的子序列
- angular - 离子无线电组 ng-model select
- css - 通过 gulp 运行时,我的 scss 没有被转换为 css
- c - 条件编译#if和#else(和其他)在c中的工作
- .net - Visual Studio 2017 中引用和依赖项之间的区别
- python - 在 while 循环中使用 Timeit 并增加输入大小
- php - 当脚本运行超过 30 分钟时,数据库中的 PHP 脚本更新记录
- laravel - 表单字段:姓名和电话未与 Paystack 中的请求一起传递
- python - 过滤具有另一个数据框的多个列值的数据框
- reactjs - ScrollView 和 Flexbox 的问题