wikijs Error: Database Initialization Error: create table "migrations"

Question

I am in the process of installing wikijs on CentoOS7.9

I did:

download and install node-v16.9.1-linux-x64 
yum install postgresql15-server
yum install postgresql15-contrib
/usr/pgsql-15/bin/postgresql-15-setup initdb

When I start the wikijs I get:

[root@]# node server
Loading configuration from /usr/local/wiki/config.yml... OK
2023-03-22T14:04:45.112Z [MASTER] info: =======================================
2023-03-22T14:04:45.114Z [MASTER] info: = Wiki.js 2.5.298 =====================
2023-03-22T14:04:45.115Z [MASTER] info: =======================================
2023-03-22T14:04:45.115Z [MASTER] info: Initializing...
2023-03-22T14:04:45.764Z [MASTER] info: Using database driver pg for postgres [ OK ]
2023-03-22T14:04:45.775Z [MASTER] info: Connecting to database...
2023-03-22T14:04:45.803Z [MASTER] info: Database Connection Successful [ OK ]
2023-03-22T14:04:45.820Z [MASTER] error: Database Initialization Error: create table "migrations" ("id" serial primary key, "name" varchar(255), "batch" integer, "migration_time" timestamptz) - permission denied for schema public

What can cause this issue?

Answer 1

The command that solve the problem for me : ALTER DATABASE wiki OWNER TO wikijs;