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-05-30 18:05:59 发布
sudo -u postgres psql postgres
#创建用户
CREATE USER dbuser;
#创建数据库
CREATE DATABASE exampledb OWNER dbuser;
#增加权限
alter role yanzeng with createdb;
alter role "yanzeng-li" with createdb;