PostgreSQL安装和使用

[WALL-E]

PostgreSQL Yum Repository

• CentOS-6

  yum install -y https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
  yum install -y postgresql96
  yum install -y postgresql96-server
  
  service postgresql-9.6 initdb
  chkconfig postgresql-9.6 on
  service postgresql-9.6 start

• CentOS-7

  yum install -y https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
  yum install -y postgresql96
  yum install -y postgresql96-server
  
  /usr/pgsql-9.6/bin/postgresql96-setup initdb
  systemctl enable postgresql-9.6
  systemctl start postgresql-9.6
  
  /var/lib/pgsql/9.6/data/pg_hba.conf

  PostgreSQL Yum Repository

[WALL-E]

Usage

Introduction tutorial