DEV Community

Cover image for INSTALLATION OF POSTGRESQL AND INTIAL SET UP ON A LINUX SERVER.
ANDATI
ANDATI

Posted on

INSTALLATION OF POSTGRESQL AND INTIAL SET UP ON A LINUX SERVER.

#postgressql #linux #database

POSTGRESQL

Introduction
PostgreSQL is described as a powerful open source object-relational database system. Referred to as open source since its freely available for use and modification, object-relational since it merges features of relational databases with objects oriented programming concepts. It also combines with SQL language.

Significance of PostgreSQL

  • It is reliable since it adheres to ACID (Atomicity, Consistency, Isolation and Durability) properties. transactions processed are reliable thus maintaining data validity during system failures.

  • It can handle large volumes of data thus suitable for big data applications and high traffic websites.

  • Has tables partitioning features thus able to scale and maintain high performance as data grows.

-It supports wide range of data types thus offers flexibility in how data is stored and managed.

Installation of PostgreSQL.

  1. Download DBeaver app in Microsoft Store. DBeaver App

  1. Download PostgreSQL using any web broswers.Type the following link in your browser to download it. https://www.postgresql.org/download/

  2. Open DBeaver application on your computer.

  3. Press CTRL+SHIFT+N to set up a new connection. Select PostgreSQL.

  1. Select next, enter connection details and test the connection then finish

LINUX SERVER
It is a computer system that uses linux operating system. It's purpose is to handle network services and resource management for multiple users and applications.

How to set up postgreSQL database on a Linux server

  1. Download a Git Bash app from any web browser using the following link: https://git-scm.com/. Git Bash acts as terminal emulator

  2. Connect to your linux server via Git Bash by typing the following code: ssh username@ip.port and run it.

  1. Select yes by pressing any key as instructed. Enter password to your linux server.

  2. Test PostgreSQL connection status via DBeaver app as stated earlier.

  3. Start and enable postgresql service using the following code
    sudo systemctl start postgresql
    sudo systemctl enable postgresql

  4. Connect to your PostgreSQL server using the following code:
    psql -U postgres.

Top comments (0)