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]:

exclude=postgresql*

Test¶

the listing of available repositories should now include pgdg93

yum repolist