CentOS下yum安装PostgreSQL

分类:CentOS运维 阅读:94137 次

Configure YUM repository

vim /etc/yum.repos.d/CentOS-Base.repo

[base] and [updates] sections添加:

exclude=postgresql*

Install PGDG RPM file

gohttp://yum.postgresql.organd find your correct RPM.

For example, to install PostgreSQL 9.3 on CentOS 6 64-bit:

打开http://yum.postgresql.org/repopackages.php#pg93后找到CentOS 6 - x86_64

then:

yum localinstall http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

Install PostgreSQL

list available packages:

yum list postgres*

For example, to install a basic PostgreSQL 9.3 server:

yum install postgresql93-server

Other packages can be installed according to your needs.

配置

After installing the packages, a database needs to be initialized and configured.

PostgreSQL data directory(/var/lib/pgsql/9.3/data) contains all of the data files for the database.

Initialize

The first command (only needed once) is to initialize the database:

service postgresql-9.3 initdb 正在初始化数据库: [确定]

Startup

开机启动:

chkconfig postgresql-9.3 on service postgresql-9.3 start

艺搜参考

https://wiki.postgresql.org/wiki/YUM_Installation