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¶

latest repo-package from * 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 

On CentOS, edit CentOS-Base.repo.

vim CentOS-Base.repo

Add to the bottom of the sections [base] and [updates]:
<file>
exclude=postgresql*
</file>

Test¶

the listing of available repositories should now include pgdg93

yum repolist