[root@~]#su - postgres Last login: Wed Apr 1 10:28:10 CST 2015 on pts/2 -bash-4.2$ psql -U postgres psql (9.4.0) Type "help" for help. postgres=#create user root with password ‘password‘; CREATE ROLE postgres=# GRANT ALL PRIVILEGES ON DATABASE mydatabase to root; GRANT postgres=# ALTER ROLE root WITH SUPERUSER; postgres=# \q
仅供个人测试时使用
FATAL: role "root" does not exist解决办法
原文：http://my.oschina.net/u/1756290/blog/394607