dotoj@Genshin-Impact-Server:/$ lsb_release -a No LSB modules are available. Distributor ID: Linuxmint Description: Linux Mint 21.3 Release: 21.3 Codename: virginia
GRUB_CMDLINE_LINUX_DEFAULT="quiet splash" ^ old --- new v GRUB_CMDLINE_LINUX_DEFAULT="quiet splash systemd.unified_cgroup_hierarchy=0 cgroup_enable=memory swapaccount=1"
-- 确保这里的密码与 */appsettings.json 中 PgSqlConnection 的密码一致 CREATEUSER webapp WITH PASSWORD 'aaaaaaa'; CREATEUSER worker WITH PASSWORD 'bbbbbbb'; CREATEUSER plagiarism WITH PASSWORD 'ccccccc';
\c judge; -- 注意!这里需要输密码,不要一下子全粘贴进去
GRANTCONNECTON DATABASE judge TO webapp; GRANTALL PRIVILEGES ONALL TABLES IN SCHEMA public TO webapp; GRANTALL PRIVILEGES ONALL SEQUENCES IN SCHEMA public TO webapp; GRANTALL PRIVILEGES ONALL FUNCTIONS IN SCHEMA public TO webapp; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON TABLES TO webapp; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON SEQUENCES TO webapp; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON FUNCTIONS TO webapp;
GRANTCONNECTON DATABASE judge TO worker; GRANTALL PRIVILEGES ONALL TABLES IN SCHEMA public TO worker; GRANTALL PRIVILEGES ONALL SEQUENCES IN SCHEMA public TO worker; GRANTALL PRIVILEGES ONALL FUNCTIONS IN SCHEMA public TO worker; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON TABLES TO worker; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON SEQUENCES TO worker; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON FUNCTIONS TO worker;
GRANTCONNECTON DATABASE judge TO plagiarism; GRANTALL PRIVILEGES ONALL TABLES IN SCHEMA public TO plagiarism; GRANTALL PRIVILEGES ONALL SEQUENCES IN SCHEMA public TO plagiarism; GRANTALL PRIVILEGES ONALL FUNCTIONS IN SCHEMA public TO plagiarism; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON TABLES TO plagiarism; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON SEQUENCES TO plagiarism; ALTERDEFAULT PRIVILEGES IN SCHEMA public GRANTALL PRIVILEGES ON FUNCTIONS TO plagiarism;