Ubuntu安装Postgresql

sudo apt-get install postgresql-9.4sudo passwd postgres切换用户su postgres登录数据库psql修改密码ALTER USER postgres with PASSWORD 'password'安装图形化工具sudo apt-get install pgadmin3启动pgadmin32个配置修改postgresql.conf:listen_addresses = '*'pg_hba.conf：# IPv4 local connections:host all all 127.0.0.1/32 md5host all all 0.0.0.0/0 md5重启服务器/etc/init.d/postgresql restarthttp://www.cnblogs.com/eastday/archive/2013/05/31/3109819.htmlhttp://my.oschina.net/weiwubunengxiao/blog/228431http://blog.chinaunix.net/uid-26275986-id-3940725.html