安裝配置Postgresql

標籤：

//關閉selinux
getenforce
setenfroce 0
vi /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted
//關閉防火牆
#chkconfig iptables off
#service iptables stop

//安裝PGSQL
# rpm --force -ivh openssl-1.0.1e-42.el6.x86_64.rpm postgresql94-libs-9.4.6-1PGDG.rhel6.x86_64.rpm postgresql94-9.4.6-1PGDG.rhel6.x86_64.rpm postgresql94-server-9.4.6-1PGDG.rhel6.x86_64.rpm postgresql94-contrib-9.4.6-1PGDG.rhel6.x86_64.rpm
#sudo rpm -aq| grep postgres
#sudo service postgresql-9.4 initdb
#sudo service postgresql-9.4 start
#sudo chkconfig postgresql-9.4 on

//pgsql 配置
# nano /var/lib/pgsql/9.4/data/postgresql.conf
修改下列兩個參數：
listen_addresses = ‘*‘
port = 5432
# nano /var/lib/pgsql/9.4/data/pg_hba.conf
修改參數如下：
# IPv4 local connections:
host all all 127.0.0.1/32 trust

重新載入設定檔並重啟資料庫：
#/etc/init.d/postgresql-9.4 reload
#service postgresql-9.4 restart

#su – postgres
psql
alter user postgres with password ‘123456‘;
create user sample with password ‘123456‘;
create database sample;

 

安裝配置Postgresql