How to get Postgresql 13 on AWS Ec2 Amazon linux 2

How to get Postgresql 13 on AWS Ec2 Amazon linux 2

This guide is about How to get Postgresql 13 on AWS Ec2 Amazon linux 2. So read this free guide, How to get Postgresql 13 on AWS Ec2 Amazon linux 2 step by step. If you have query related to same article you may contact us.

How to get Postgresql 13 on AWS Ec2 Amazon linux 2 – Guide

PostgreSQL developers call this platform “the most advanced open source database in the world”. PostgreSQL is available for Linux, including other common operating systems such as macOS, Windows and BSD. PostgreSQL implements the 2008 SQL standard very comprehensively. In addition to the common data types, the database can also handle XML natively and version 9.2 with data in JSON format. Here, we learned the steps to install PostgreSQL on Amazon Linux 2 running on the AWS ec2 instance.

What do you need to install PostgreSQL database?

  • 1GB hard drive space
  • 2 GB of memory
  • Since the core of the Virtual CPU
  • Connect Amazon Linux via SSH OR Web Terminal
  • sudo rights
  • Step 1: Enable the EPEL repository

    As the PostgreSQL YUM repository depends on the EPEL repository for some packages. We need to install EPEL repo RPM along with PGDG repo RPMs to satisfy dependencies on our Amazon Linux 2 Server.

    Run the command below to activate the EPEL repository on the Amazon Linux 2 server:

    Accept the installation by pressing the y key when prompted.

    Step 2: Install PostgreSQL 13 on Amazon Linux 2

    Below are the minimum requirements for installation in the production configuration.

  • 2GB RAM recommended
  • 1 virtual cpu core
  • 1GB of disk space for installation
  • You also need SSH access to the server as a user with sudo privileges.
  • Run the following commands to ensure the PGDG repository is added to your Amazon Linux 2 server.

    Once the repository has been added, run the necessary commands to install PostgreSQL 13 on Amazon Linux 2:

    Check that the correct PostgreSQL software versions are being installed.

    Step 3: Initialize and Start the Database Service

    You need to generate the initial database settings file before starting the service.

    The main database server configuration file is /var/lib/pgsql/12/data/postgresql.conf .

    From the news www.how2shout.com

    Final note

    I hope you like the guide How to get Postgresql 13 on AWS Ec2 Amazon linux 2. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.

    We will be happy to hear your thoughts

        Leave a reply

        Compsmag
        Logo