PostgreSQL YUM Installation

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 (otherwise dependencies might resolve to the postgresql supplied by the base repository):

exclude=postgresql*

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.3 on CentOS 6 64-bit:

yum localinstall http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

Install PostgreSQL

To list available packages:

yum list postgres*

For example, to install a basic PostgreSQL 9.3 server:

yum install postgresql93-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.

In the commands below, the value of will vary depending on the version of PostgreSQL used.

For PostgreSQL version 9.0 and above, the includes the major.minor version of PostgreSQL, e.g., postgresql-9.3

For versions 8.x, the is always postgresql (without the version signifier).

Data Directory

The PostgreSQL data directory contains all of the data files for the database. The variable PGDATA is used to reference this directory.

For PostgreSQL version 9.0 and above, the default data directory is:

/var/lib/pgsql/<name>/data

For example:

/var/lib/pgsql/9.3/data

Initialize

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

service <name> initdb

E.g. for version 9.3:

service postgresql-9.3 initdb

If the previous command did not work, try directly calling the setup binary, located in a similar naming scheme:

/usr/pgsql-y.x/bin/postgresqlyx-setup initdb

E.g. for version 9.3:

/usr/pgsql-9.3/bin/postgresql93-setup initdb

Startup

If you want PostgreSQL to start automatically when the OS starts:

chkconfig <name> on

E.g. for version 9.3:

chkconfig postgresql-9.3 on

Control service

To control the database service, use:

service <name> <command>

where 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

E.g. to start version 9.3:

service postgresql-9.3 start

Test Database

Removing

To remove everything:

yum erase postgresql93*

Or remove individual packages as desired.

Python Support

yum install postgresql93-devel

and try compiling PostgreSQL and including generated bin files in your $PATH? Like:

export PATH=/path/to/compiled/postgresql/bin:"$PATH"

than

pip install psycopg2