How to Install PostgreSQL 12 on CentOS

When it comes to choosing a reliable and user-friendly database management system, PostgreSQL stands out as one of the best options. Not only is it easy to install, but also safe and up-to-date, making it an ideal choice for many users.

For those using CentOS 8 or its derivatives, installing PostgreSQL 12 is a straightforward process that can be completed in just a few steps. In this article, we'll guide you through the process of installing PostgreSQL 12 on your CentOS system.

Add the Official PostgreSQL Repository

The first step to installing PostgreSQL 12 is to add the official PostgreSQL repository to your system. This ensures that you have access to the latest versions and updates for your database management system.

To add the repository, open a terminal window and run the following command:

```

sudo yum install epel-release

```

Once the repository has been added, update your package list by running the following command:

```

sudo yum update

```

Install PostgreSQL 12

With the repository updated, you can now install PostgreSQL 12 on your CentOS system. Run the following command to download and install the software:

```

sudo yum install postgresql12-server

```

The installation process may take a few minutes to complete, depending on your internet connection speed.

Configure PostgreSQL 12

Once the installation is complete, you'll need to configure your PostgreSQL database by creating a password for the `postgres` user and setting up the database configuration files. You can do this by running the following commands:

```

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb

```

Start the PostgreSQL Service

With PostgreSQL 12 installed and configured, you'll need to start the service so that it's available for use. Run the following command to start the PostgreSQL service:

```

sudo systemctl start postgresql-12.service

```

Verify the Installation

To verify that your installation was successful, you can check the PostgreSQL version by running the following command:

```

psql --version

```

This should display the version number of PostgreSQL 12.

In conclusion, installing PostgreSQL 12 on CentOS is a straightforward process that requires only a few steps. By following these instructions, you'll have a fully functional database management system up and running in no time.

Centos install postgresql 12