postgres permission denied for schema public的解決方法

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

然後報錯postgres permission denied for schema public

解決方法如下

GRANT ALL ON DATABASE mattermost TO mmuser;
ALTER DATABASE mattermost OWNER TO mmuser;
GRANT USAGE, CREATE ON SCHEMA PUBLIC TO mmuser;

postgres 15因為安全問題所以出現上面的問題。