sudo -u postgres psql postgres
#创建用户
CREATE USER dbuser;
#创建数据库
CREATE DATABASE exampledb OWNER dbuser;
#增加权限
alter role yanzeng with createdb;
alter role "yanzeng-li" with createdb;
postgre 第一次登录
最新推荐文章于 2024-06-20 15:11:19 发布
sudo -u postgres psql postgres
#创建用户
CREATE USER dbuser;
#创建数据库
CREATE DATABASE exampledb OWNER dbuser;
#增加权限
alter role yanzeng with createdb;
alter role "yanzeng-li" with createdb;