pgsql添加删除用户权限，配置公网访问说明

进入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;

修改密码：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