PostgreSQL RPM Building Project - Yum Repository Howto

Last updated: Tue Nov 18, 2008

Please click here and download the repository RPM based on your distro and PostgreSQL version you want. The link will be opened in a new window / tab.

Installation procedure and details

*Some external help: *

Important note:

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

  • As root, cd /etc/yum.repos.d
    • Edit distro's .repo file:
      • On Fedora, edit fedora.repo and fedora-updates.repo, [fedora] sections
      • On CentOS, edit CentOS-Base.repo, [base] and [updates] sections.
      • On Red Hat, edit edit /etc/yum/pluginconf.d/rhnplugin.conf [main] section.
        • Add to the bottom of the section:

--integer-datetimes supported RPMS

These packages are distributed via a seperate channel, called pgdg83-id. Before using these sets, please make sure that you have latest repository RPM installed on your system. If you want to use these sets, enable pgdg83-id repository. You don't need to disable pgdg83 repository, since -id repository will always have a higher priority, and only postgresql with --integer-datetimes supported packages will be available in pgdg83-id channel.

NOTE: up2date, which is shipped with RHEL4 cannot be used with this repository. Newer repository creation evironments don't support up2date. RHEL 4 users need to use yum.