DokuWiki » Infrastructure » Operating System » CentOS 6

h1. postgresql repository

h2. 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

h2. 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@

h2. Install Package

<pre><code class="bash">

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

</code></pre>

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

h2. 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:

<pre><code class="bash">

cd /etc/yum.repos.d 

</code></pre>

On CentOS, edit @CentOS-Base.repo@. 

<pre><code class="bash">

vim CentOS-Base.repo

</code></pre>

Add to the bottom of the sections @[base]@ and @[updates]@: 

<file>

exclude=postgresql*

</file>

h2. Test

the listing of available repositories should now include @pgdg93@

<pre><code class="bash">

yum repolist

</code></pre>