Fork me on GitHub

postgresql

 

 

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

 

posted on 2016-04-23 23:12  阳光-源泉  阅读(295)  评论(0编辑  收藏  举报

导航