首页 > 数据库技术 > 详细

postgresql

时间:2016-04-24 00:48:52      阅读:332      评论:0      收藏:0      [点我收藏+]

 

 

yum install elinks
rpm -ql postgresql|more
elinks /usr/share/doc/postgresql-9.2.15/html



initdb -D /var/lib/pgsql/data/
pg_ctl -D /var/lib/pgsql/data -l logfile start
export PGDATA=/var/lib/pgsql/data
pg_ctl restart

bash-4.2$ psql
psql (9.2.15)
Type "help" for help.

postgres=# \password postgres

bash-4.2$ vi postgresql.conf

listen_addresses = ‘*‘          # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to ‘localhost‘; use ‘*‘ for all
                                        # (change requires restart)
port = 5432                             # (change requires restart)


bash-4.2$ vi pg_hba.conf

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all             all             192.168.1.0/24            trust

 

postgresql

原文:http://www.cnblogs.com/createyuan/p/5426020.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!