安装配置Postgresql

时间:2023-02-15 21:31:10

//关闭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;