Well, we should also mark the service of PostgreSQL enabled, so that it can start atomically, if crashed or with system boot. OK that means everything is fine and we can start the Database server services, using: sudo systemctl start postgresql-14 OK Step 5: Start and Enable the PostgreSQL Service In return you will get: Initializing database. sudo /usr/pgsql-14/bin/postgresql-14-setup initdb For that use initdb which will create a new PostgreSQL database cluster refers to a collection of databases managed by a single server instance. Now, before starting and enabling the service of the Database, let’s initialize it. We have followed all the necessary steps so far to have a working PostgreSQL Database on our Linux system. sudo yum install postgresql14 postgresql14-server Step 4: Initialize the Database sudo yum update Step 3: Installing Postgresql 14 on Amazon Linux 2Īfter adding the repo and updating the package repository, we can install the PostgreSQL package and its dependencies on Amazon Linux like any other software via YUM. Name=PostgreSQL 14 for RHEL/CentOS 7 - x86_64Īfter adding the repo, run the system update command, once again. Therefore, those who are interested in Postgresql 14 need to add the PGDG14 repo manually using the command given below:Ĭopy whole block of the given command and paste it as it is: sudo tee /etc//pgdg.repo<Ofcourse, an active internet connection to download the PostgreSQL packages.

To install packages we need sudo or root user access.

At least 1GB of free Hard disk space, 2GB of RAM, and a single-core CPU.

Amazon Linux 2 server either on a local virtual machine, Docker, or AWS EC2 Instance.

Let’s first confirm, you have all the necessary things to follow this tutorial:

Yum install postgresql client