Install PostgreSQL on CentOS

Install PostgreSQL on CentOS
— filed under: PostgreSQL, CentOS

How to install PostgreSQL Server on CentOS

1. Download yum repository rpm for your arch and version you want to use:

http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html

2. install rpm file

rpm -i <file>.rpm

3. modify CentOS Repository

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

add this line:

exclude=postgresql*

should look like this:

[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
exclude=postgresql*



4. install PostgreSQL

yum install postgresql-server

5.initialize PostgreSQL-Database

service postgresql initdb

6. start service

service postgresql start

7. if you want postgresql to be started at boot time run this:

chkconfig --levels 35 postgresql on