1. Home
2. Browse Collections
3. Software Collections
4. PostgreSQL 9.5

rh-postgresql95 - A recent stable release of PostgreSQL. This version provides a number of new features and enhancements:

• INSERT operations that would generate constraint conflicts are now allowed to be turned into UPDATE operations or ignored (UPSERT operations)

• GROUP BY analysis features have been added: GROUPING SETS, CUBE, and ROLLUP

• Row-level security control has been added

• Mechanisms for tracking the progress of replication have been created, including methods for identifying the origin of individual changes during logical replication

• Block Range Indexes (BRIN) have been added

• Substantial performance improvements for sorting

• Substantial performance improvements for multi-CPU machines

EL6 tests EL7 tests

Instructions

You can get started in three easy steps:

# 1. Install a package with repository for your system:
# On CentOS, install package centos-release-scl available in CentOS repository:
$ sudo yum install centos-release-scl

# On RHEL, enable RHSCL repository for you system:
$ sudo yum-config-manager --enable rhel-server-rhscl-7-rpms

# 2. Install the collection:
$ sudo yum install rh-postgresql95

# 3. Start using software collections:
$ scl enable rh-postgresql95 bash

At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run:

$ postgresql-setup --initdb
$ service rh-postgresql95-postgresql start
$ psql

Since su and sudo commands clear environment variables, we need to run scl enable once again for example after switching to postgres user role:

$ su - postgres -c 'scl enable rh-postgresql95 -- psql'

In order to view the individual components included in this collection, including additional subpackages, you can run:

$ sudo yum list rh-postgresql95\*

PostgreSQL Software Collection as Docker Formatted Container

On CentOS 7 and RHEL 7 you can pull the image with the following command:

$ docker pull registry.access.redhat.com/rhscl/postgresql-95-rhel7
$ docker pull centos/postgresql-95-centos7

For more on the docker image follow the link to public source repository: https://github.com/sclorg/postgresql-container

Policy

Community Project: Maintained by upstream communities of developers. The software is cared for, but the developers make no commitments to update the repositories in a timely manner.

Yum Repositories

Operating system	Package with repo	Browse files
CentOS 6	yum install centos-release-scl-rh	x86_64
CentOS 7	yum install centos-release-scl-rh	x86_64
RHEL 6	yum-config-manager --enable rhel-server-rhscl-6-rpms
RHEL 7	yum-config-manager --enable rhel-server-rhscl-7-rpms

Tags

Rating