centos 安裝PGSQL

標籤：

centos 安裝PGSQL
CentOS下yum安裝PostgreSQL
目錄
1 Configure YUM repository
2 Install PGDG RPM file
3 Install PostgreSQL
4 配置
5 Initialize
6 Startup

具體步驟：
1.
vim /etc/yum.repos.d/CentOS-Base.repo
[base] and [updates] sections添加：
exclude=postgresql*

2.Install PGDG RPM file
http://yum.postgresql.org 官網找到下載版本的rpm下載路徑，執行如下操作：
yum localinstall http://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm

3. Install PostgreSQL
3.1 list available packages:
yum list postgres*
3.2 For example, to install a basic PostgreSQL 9.5 server:
yum install postgresql95-server
3.3 Other packages can be installed according to your needs.

4.配置

After installing the packages, a database needs to be initialized and configured.
PostgreSQL data directory（/var/lib/pgsql/9.5/data） contains all of the data files for the database.
5. Initialize

5.1 The first command (only needed once) is to initialize the database：
service postgresql-9.5 initdb
正在初始化資料庫： [確定]

6. Startuph

設定開機啟動：
chkconfig --level 2345 postgresql-9.5 on
service postgresql-9.5 start

centos 安裝PGSQL