yum -y install postgresql postgresql-libs postgresql-server
service postgresql start
设置为开机启动 chkconfig postgresql on
然後修改/var/lib/pgsql/data/pg_hba.conf的設定:
# "local" is for Unix domain socket connections only #local all all ident sameuser local all all trust # IPv4 local connections: #host all all 127.0.0.1/32 ident sameuser host all all 127.0.0.1/32 md5
再通知postmaster我們變動了設定即可
su - postgres pg_ctl reload
如果還要讓其他外部機器連進來的話,修改/var/lib/pgsql/data/postgresql.conf
PostgreSQL version 8.xlisten_addresses = '*'
然後在/var/lib/pgsql/data/pg_hba.conf加上要連進來的主機的設定,例如讓某個class C網段的機器都可以連進來:
1 | host all all 192.168 . 1.0 / 24 md5 |
su - postgres
pg_ctl reload