加入pgweb部署 - Githubissues

prajnamort / LambdaOJ2

MIT License

3 stars 5 forks source link

加入pgweb部署 #10

Closed kainwen-zz closed 7 years ago

kainwen-zz commented 7 years ago

加入pgweb部署

只有read权限
pgweb被supervisor启动

kainwen-zz commented 7 years ago

创建一个postgres的普通账户
只给他grant lambdaoj这个数据库里的(main_*)的只读权限，别的表连只读都没有
pgweb开启的时候，要加参数，pgweb好像就有readonly模式。然后只开一个session。
开机自启动，最好加入在supervisor下

kainwen-zz commented 7 years ago

create role xxx with login CONNECTION LIMIT 1 PASSWORD abcd ENCRYPTED
grant CONNECT on database lambdaoj
grant usage on schema yyy to xxx
grant select on yyy.??? to xxx

prajnamort commented 7 years ago

Done.