PostgreSQL - Zero to Hero (part 2)

PostgreSQL - Running Multiple Instances Running PostgreSQL 11 and PostgreSQL 10, or any combination of major versions, on a single system is easy when using RPM packages such as the ones provided at PostgreSQL YUM reposiotry. PGDG rpms make it easy to run multiple version of PostgreSQL on a single system. Install one more PGDG versions, setup, enable services using steps shared in previous blog. This guide will help you get started with installing and configuring multiple PostgreSQL 11 clusters on a CentOS / RHEL 7 based system, which will also work for Fedora 27, 28, 29.

PostgreSQL - Zero to Hero (part 1)

PostgreSQL - Installing and Creating cluster One of the most important things to using PostgreSQL successfully in your development and production environments is simply getting started! One of the most popular ways to install PostgreSQL is by using RPM packages. The PostgreSQL RPM packages work across many Linux distributions, including, RedHat Enterprise Linux (RHEL), CentOS, Fedora, Scientific Linux, and more, and the PostgreSQL community provides installers for these distributions.

Setup RPM Build ENV

Install required packages sudo yum install rpm-build redhat-rpm-config yum-utils Setup build environment mkdir -p ~/rpmbuild/{BUILD,RPMS,SOURCES,SPECS,SRPMS} echo '%_topdir %(echo $HOME)/rpmbuild' > ~/.rpmmacros Download src rpm and save it to ~/rpmbuild/SRPMS/ Install build dependencies for package sudo yum-builddep <package> Build package rpmbuild --rebuild <package>.

CentOS 7 Installation

For CentOS 6 users it may be difficult to understand and use new CentOS 7 installer but for Fedora users it is an easy one. To ease the life of new CentOS 7 users, here are steps for minimal CentOS 7 install. Boot from DVD Select Install CentOS 7 by pressing ↑ and press ↵ Language Selection Select your language and Click “continue” Installation Summary This is the main install setup screen.