Home PostgreSQL PostgreSQL 13.0 installation step by step process

PostgreSQL 13.0 installation step by step process

0
107

PostgreSQL also know as Postgres , the world’s most advanced open source database, is a free and open-source RDBMS emphasizing extensibility and SQL compliance. PostgreSQL 13  is released on 24th Sept, 2020 by The PostgreSQL Global Development Group . PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows.

New Features of PostgreSQL 13.0:

PostgreSQL 13 contains many new features and enhancements, including:

      • Space savings and performance gains from de-duplication of B-tree index entries

      • Improved performance for queries that use aggregates or partitioned tables

      • Better query planning when using extended statistics

      • Parallelized vacuuming of indexes

      • Incremental sorting

Installation Steps:

Following step by step installation process is for RHEL, CentOS, Scientific or Oracle Version 8. For different environment installation please check link. Choose your  OS and OS version to get appropriate packages and its installation steps.

# Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:
sudo dnf -qy module disable postgresql

# Install PostgreSQL:
sudo dnf install -y postgresql13-server


# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

#Check status of the database service.
sudo systemctl status postgresql-13.service
#Check location of Data Directory and Location of Configuration file
#su - posgres
#psql
#You can edit pg_hba.conf file to provide access to specific persons and access the same through PGAdmin4 or SQL developer.