YUM Installation

From PostgreSQL wiki

PostgreSQL can be installed using RPMs (binary) or SRPMs (source) managed by YUM. This is available for the following Linux distributions (both 32- and 64-bit platforms):

• Fedora (versions 7 and up)
• Red Hat Enterprise Linux (versions 4 and up)
• CentOS (versions 4 and up)

See links from the main repository, http://yum.postgresql.org:

• A list of available packages
• Status of RPM builds

Contents 1 Instructions 1.1 Configure your YUM repository 1.2 Download and install PGDG RPM file 1.3 Install PostgreSQL 1.4 Post-installation commands 1.4.1 Initialize 1.4.2 Startup 1.5 Control service 2 Removing 3 Support 4 See also

Instructions

Configure your YUM repository

Locate and edit your distributions .repo file, located:

• On Fedora: /etc/yum.repos.d/fedora.repo and /etc/yum.repos.d/fedora-updates.repo, [fedora] sections
• On CentOS: /etc/yum.repos.d/CentOS-Base.repo, [base] and [updates] sections
• On Red Hat: /etc/yum/pluginconf.d/rhnplugin.conf [main] section

To the section(s) identified above, you need to append a line:

exclude=postgresql*

Download and install PGDG RPM file

A PGDG file is available for each distribution/architecture/database version combination. Browse http://yum.postgresql.org and find your correct RPM. For example, to install PostgreSQL 9.1 on CentOS 6 32-bit:

curl -O http://yum.postgresql.org/9.1/redhat/rhel-6-i386/pgdg-centos91-9.1-4.noarch.rpm

Now install RPM distribution:

rpm -ivh pgdg-centos91-9.1-4.noarch.rpm

Install PostgreSQL

To list available packages:

yum list postgres*

For example, to install a basic PostgreSQL 9.1 server:

yum install postgresql91-server

Other packages can be installed according to your needs.

Post-installation commands

After installing the packages, a database needs to be initialized and configured.

For PostgreSQL version 9.0 and above, the <name> is postgresql-9.1, and the PGDATA directory is:

/var/lib/pgsql/9.1/data

For versions 7.x and 8.x, the <name> is always postgresql, and the PGDATA directory is:

/var/lib/pgsql/data/

Initialize

The first command (only needed once) is to initialize the database in PGDATA:

service <name> initdb

Startup

If you want PostgreSQL to startup automatically on reboot:

chkconfig <name> on

Control service

To control the database service, use:

service <name> <command>

where <command> can be:

• start : start the database
• stop : stop the database
• restart : stop/start the database; used to read changes to core configuration files
• reload : reload pg_hba.conf file while keeping database running

Removing

To remove everything:

yum erase postgresql91*

Or remove individual packages as desired.

Support

• Email: pgsqlrpms-hackers@PgFoundry.org

See also

• RPM Installation