安装配置Postgresql
//关闭selinux
getenforce
setenfroce 0
vi /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted
//关闭防火墙
#chkconfig iptables off
#service iptables stop
//安装PGSQL
//安装或者升级openssl,根据具体依赖提示操作
# rpm --force -ivh openssl-1.0.1e-42.el6.x86_64.rpm
//centos 7 还需要安装
#yum install libxslt.x86_64 -y
#rpm -ivh 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;