Skip to content
bash
# 进入主节点容器
$ docker exec -it postgres bash

# 进入pg命令行
$ psql -U postgres
sql
create user n8n_admin with password 'n8npassword';
CREATE DATABASE n8n OWNER n8n_admin;
GRANT ALL PRIVILEGES ON DATABASE n8n TO n8n_admin;
sql
create user nuxt_admin with password 'nuxtpassword';
CREATE DATABASE nuxt_db OWNER nuxt_admin;
CREATE DATABASE nuxt_db_shadow OWNER nuxt_admin;
GRANT ALL PRIVILEGES ON DATABASE nuxt_db TO nuxt_admin;
GRANT ALL PRIVILEGES ON DATABASE nuxt_db_shadow TO nuxt_admin;