DS Log

In my blog, I delve into the world of programming web technologies, Linux, Unix-like, and graphic design using free tools on Linux.

Monday, July 15, 2024

How to install PostgreSQL on Ubuntu Linux?

PostgreSQL is a powerful open source relational database management system (RDBMS) known for its robustness, extensibility and compliance with SQL standards. It is often called “Postgres” or “PostgreSQL”. PostgreSQL offers a wide range of features and capabilities that make it suitable for a variety of applications, from small projects to large enterprise systems.

Preparation

First we need to update the system:

sudo apt update && sudo apt upgrade

Then we install the packages:

sudo apt install postgresql postgresql-contrib 

pgAdmin

pgAdmin is an open source tool for administration and management of the PostgreSQL database system. It is a comprehensive graphical user interface (GUI) application that allows users to interact with PostgreSQL databases and perform various tasks such as creating, managing, and querying databases, executing SQL queries, designing database schemas, and monitoring database activity. pgAdmin provides a user interface that simplifies the administration of PostgreSQL databases, making it easier for developers, database administrators, and other users to work with the database system.

Installation

Let's install curl (if we don't already have it):

sudo apt install curl 

Let's take the key:

sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

Next, we download the package:

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

And finally, the installation itself:

sudo apt install pgadmin4

The installed program is in the start menu:

posted by damirs @ July 15, 2024