postgresql repository¶

preliminary note¶

the postgresql repo contains the latest version of postgresql and is updated frequently. As a result the postgresql-packages of the base system must be excluded

Download postgresql package¶

• http://www.pgrpms.org/repopackages.php
  as of 2013-09-12 this is pgdg-centos93-9.3-1.noarch

Install Package¶

yum install pgdg-centos93-9.3-1.noarch.rpm

This will add a yum repository config file and import the appropriate GPG keys.

Exclude postgresql in Base-Repo¶

In order to use PGDG repository properly, you may need to exclude postgresql packages from the repository of the distro. Here are the steps:

cd /etc/yum.repos.d 

vim CentOS-Base.repo

exclude=postgresql*

Test¶

the listing of available repositories should now include pgdg93

yum repolist