进入pgsql: psql -U username -d dbname;
创建用户:create role u1 with login password '123456';
查看角色信息:select * from pg_roles;
赋予u1对表的只读权限
grant select on t1 to u1; //t1表
grant select on t1 in schema public to u1; //所有表
删除权限:revoke select on t1 from u1;
删除用户:drop role u1;
创建用户:create role u1 with login password '123456';
查看角色信息:select * from pg_roles;
赋予u1对表的只读权限
grant select on t1 to u1; //t1表
grant select on t1 in schema public to u1; //所有表
删除权限:revoke select on t1 from u1;
删除用户:drop role u1;
修改密码:alter user postgres with password 'foobar';
#修改监听端口和地址
vi /var/lib/pgsql/data/postgresql.conf
#修改
listen_addresses = '*'
port = 5432
#允许远程连接:
vi /var/lib/pgsql/data/pg_hba.conf
#修改
host all all 0.0.0.0/0 trust
#启动
service postgresql start
#关闭
service postgresql stop
推荐参考:
https://my.oschina.net/aven92/blog/528943?p=1
http://blog.csdn.net/italyfiori/article/details/43966109
http://www.jb51.net/article/40300.htm
http://blog.csdn.net/smstong/article/details/17138355