知乎专栏 |
创建一个远程维护数据库dba用户,具有创建数据库与创建用户的权限
CREATE USER dba PASSWORD 'dba' CREATEDB CREATEUSER;
进入psql
$ psql psql (9.1.6) Type "help" for help. postgres=# CREATE USER dba PASSWORD 'dba' CREATEDB CREATEUSER; CREATE ROLE postgres=# \q
使用psql登录
$ psql -hlocalhost -Udba postgres Password for user dba: psql (9.1.6) SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Type "help" for help. postgres=#