Skip to main content

Installing PostgreSQL on CentOS

Hands-On Lab

 

Photo of Landon Fowler

Landon Fowler

Database Training Architect II

Length

00:15:00

Difficulty

Intermediate

PostgreSQL is the world's most advanced open source database. It's stability, functionality, and extensibility make it a primary choice for an RDBMS solution.

In this hands-on lab scenario you are the DBA for Awesome Company. You have been tasked with building a PostgreSQL database backend to facilitate the development of a new web application. This will help you become familiar with how to install the software, initialize the database, and make an initial connection as the administrative user.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.

Installing PostgreSQL on CentOS

Introduction

PostgreSQL is the world's most advanced open source database. It's stability, functionality, and extensibility make it a primary choice for an RDBMS solution.

The Scenario

We are the DBAs for Awesome Company, and have been tasked with building a PostgreSQL database backend to facilitate the development of a new web application. This will be accomplished by:

  • Installing version 12 of the PostgreSQL software
  • Initializing the database
  • Connecting as the default user

Logging In

Use the credentials provided on the hands-on lab overview page, and log in as cloud_user.

Install the PostgreSQL Software

  • Open the distribution .repo file in vi:

    $ sudo vi /etc/yum.repos.d/CentOS-Base.repo
  • Exclude PostgreSQL by appending the following line to both the [base] and [updates] sections:

    $ exclude=postgresql*
    • Put a blank line in after each of these, between them and the sections that follow them.
  • Download and install the PGDG file from postgresql.org:

    $ sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
  • Install PostgreSQL 12:

    $ sudo yum install -y postgresql12-server postgresql12-contrib

Initialize the Database

  • Initialize the database:
    $ sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
  • Start and enable the postgresql-12 service:
    $ sudo systemctl start postgresql-12
    $ sudo systemctl enable postgresql-12

Connect as the Default User

  • Change to the postgres user and launch psql:
    $ sudo su - postgres
    $ psql

Conclusion

That last psql command should land us at a PostgreSQL prompt. This means that everything is installed and running. Congratulations!