postgres permission denied for schema public的解決方法
然後報錯postgres permission denied for schema public
1
2
3
4
5
6
7
sudo -u postgres psql
create database misskey with encoding = 'UTF8';
create user misskey with encrypted password '{YOUR_PASSWORD}';
grant all privileges on database misskey to misskey;
\q
解決方法如下
1
2
3
4
5
GRANT ALL ON DATABASE mattermost TO mmuser;
ALTER DATABASE mattermost OWNER TO mmuser;
GRANT USAGE, CREATE ON SCHEMA PUBLIC TO mmuser;
postgres 15因為安全問題所以出現上面的問題。