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

postgresql92 - A recent stable release of PostgreSQL. This version provides a number of new features and enhancements, including cascading replication, native JSON support, improved scalability, and better performance.

This collection is EOL since Oct 2016.

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 postgresql92

# 3. Start using software collections:
$ scl enable postgresql92 bash

At this point you should be able to use PostgreSQL just as a normal application. Some examples of new available commands follow:

$ postgresql-setup --initdb
$ service postgresql92-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 postgresql92 -- psql'

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

$ sudo yum list postgresql92\*

PostgreSQL Software Collection as Docker Formatted Container

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

$ docker pull openshift3/postgresql-92-rhel7

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 Nov. 11, 2015, 1:24 p.m.

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