centos 6.8 + yum + pgsql9.6

安装centos 6.8

配置yum cdrom源

cd /etc/yum.repos.d
mv ./CentOS-Base.repo ./CentOS-Base.repo.bak
mv ./CentOS-Debuginfo.repo ./CentOS-Debuginfo.repo.bak
mv ./CentOS-fasttrack.repo ./CentOS-fasttrack.repo.bak
mv ./CentOS-Media.repo ./CentOS-Media.repo.bak
mv ./CentOS-Vault.repo ./CentOS-Vault.repo.bak

vi ./CentOS-Cdrom.repo
[c6-cdrom]
name=CentOS-$releasever - Media
baseurl=file:///mnt/cdrom/
gpgcheck=0
enabled=1
gpgkey=file:///mnt/cdrom/RPM-GPG-KEY-CentOS-6

如果要安装cdrom没有的包，就需要配置外源，比如aliyun 源

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

yum makecache

安装pgsql9.6

安装 repository rpm:

yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm

pgdg-centos96-9.6-3.noarch.rpm 安装后，会生成一个 repo 文件

cat /etc/yum.repos.d/pgdg-96-centos.repo
[pgdg96]
name=PostgreSQL 9.6 releasever−basearch
baseurl=https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-releasever−basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96

[pgdg96-source]
name=PostgreSQL 9.6 releasever−basearch - Source
failovermethod=priority
baseurl=https://download.postgresql.org/pub/repos/yum/srpms/9.6/redhat/rhel-releasever−basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96

[pgdg96-updates-testing]
name=PostgreSQL 9.6 releasever−basearch
baseurl=https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-releasever−basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96

[pgdg96-source-updates-testing]
name=PostgreSQL 9.6 releasever−basearch - Source
failovermethod=priority
baseurl=https://download.postgresql.org/pub/repos/yum/srpms/testing/9.6/redhat/rhel-releasever−basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96

安装postgresql rpm:

yum install postgresql96
yum install postgresql96-server

或者直接 yum install postgresql96*
这样就会安装很多包

postgresql-client libraries and client binaries
postgresql-server core database server
postgresql-contrib additional supplied modules
postgresql-devel libraries and headers for C language development
pgadmin3 - pgAdmin III graphical administration utility

初始化数据库

service postgresql-9.6 initdb
chkconfig postgresql-9.6 off
service postgresql-9.6 start

ps -ef|grep -i postgres
netstat -anop|grep -i 5432

修改些参数

alter system set listen_addresses=’*’;
atler system set port=5432;
alter system set logging_collector=on;
alter system set log_destination=’csvlog’;

一些path

/etc/alternatives/
/usr/pgsql-9.6/
/var/lib/pgsql/9.6/

/usr/share/doc/postgresql96-docs-9.6.4/
/usr/src/debug/postgresql-9.6.4/
/usr/lib/debug/usr/pgsql-9.6/
/var/lib/alternatives/