sudo -u postgres psql # 用postgres用户打开psql
CREATE USER username WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE database_name TO username;
不知道为啥这里授权不了 直接给超级管理员
ALTER USER username WITH SUPERUSER;
\q #退出
sudo vim /etc/postgresql/12/main/pg_hba.conf
#修改ip限制
host all all 0.0.0.0/0 md5
sudo vim /etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
#重启
sudo systemctl restart postgresql