Tomáš Repík

PostgreSQL and MongoDB Software Collections: Three easy steps to get started

By Tomáš Repík July 28, 2016

In the first part of my series on Software Collections (SCL), I gave general information and listed the three steps needed to get started with SCL for a number of languages. This post covers the steps for PostgreSQL and MongoDB.

Enable the SCL repository

The first step is to enable the SCL software repository if you haven’t already done so. As the root user run:

# subscription-manager repos --enable rhel-server-rhscl-7-rpms

Now onto installing the database software.

PostgreSQL

PostgreSQL is a powerful open source, object-relational, ACID compliant, database system. PostgreSQL runs on all major operating systems. Its key features are reliability, data integrity and correctness. Recently PostgreSQL 9.5 was released as part of Red Hat Software Collections (RHSCL) 2.2. A number of earlier releases (9.2 and 9.4) are also available from RHSCL.

To install the PostgreSQL 9.5 collection, run the following command as the root user:

# yum install rh-postgresql95

Now setup PostgreSQL and create the initial database. First use scl enable to add PostgreSQL to the root user’s environment, then run setup.

# scl enable rh-postgresql95 bash
# postgresql-setup --initdb

Now start the PostgreSQL server and enable it to start up when your system boots:

# systemctl start rh-postgresql95-postgresql
# systemctl enable rh-postgresql95-postgresql

To run psql as the postgres user, you need to use su as well as scl enable in order to setup that user’s environment.

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