Installing PostgreSQL pgAdmin 4 in Ubuntu 22.04 LTS

238

Today, in this article, we show how to Installing PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS. Now that you are familiar with the pgAdmin idea, according to the creators, the latest version, pgAdmin 4, required a complete rewrite of the original pgAdmin program. This version was created by combining Python and JavaScript/jQuery. Depending on your use case, you can now use pgAdmin as a desktop execution environment or as a web application server.

Due to its simplicity of use, Ubuntu Desktop, a Linux distribution or operating system created by Canonical, is one of the most used. Also, it is one of the starter options for Linux beginners. Most Internet servers also run the server edition, which we will not focus on in this article. These operating systems are typically distributed to hackers or other professional users; therefore, they are not as often used in homes.

The most effective open source management tool for Postgres, the most advanced open source database, is pgAdmin. Both inexperienced and experienced Postgres users can benefit from pgAdmin 4’s robust graphical interface, which makes it easy to create, maintain, and use database objects. We have mentioned below the steps to install PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS Jammy Linux.

Steps to Install PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS Jammy Linux

Step 1: Install PostgreSQL on Ubuntu

Before starting, update your package information using the command below. It helps to get information about updated packages and their dependencies.

sudo apt update

Then run this command to install the latest version of PostgreSQL along with a contribute package that provides additional tools and functionality for PostgreSQL.

sudo apt install postgresql postgresql-contrib

Step 2: Check the PostgreSQL Service

After completing the installation, the PostgreSQL service should be active by default. You can check it using the following command.

postgresql service status

Step 3: connect to PostgreSQL Database

By default, PostgreSQL creates a postgres user account during the installation process. You need to log in to this account to connect and access the PostgreSQL server’s working shell.

sudo su – postgres

Then type the following command to open Postgres interactive shell.

psql

You can also open the Postgres shell without switching accounts. For example, this single command will start an interactive Postgres shell as a postgres user.

sudo -u postgres psql

Likewise, PostgreSQL also creates a default database postgres During installation. The postgres user automatically connects to the postgres database when you run the psql command.

At the prompt, type the command conninfo to check the connection details.

conninfo

You can view a list of all databases using the l command.

I

To exit the interactive interface, run the command q.

q

Step 4: create a new paper

You can view a list of functions in PostgreSQL using the command du.

du

As you can see, there is only one role”postgres” which is the default role created during the installation process. It has superuser permissions and can create new roles and databases on the server.

O postgres user has no password, you have to set it yourself. For that, you must run the command below at the prompt.

ALTER USER postgres WITH PASSWORD’admin123‘;

Various roles will give you the flexibility to manage databases as different users.

You can create a new role using the createuser command. The –interactive flag will prompt you to enter the name of the new role and ask if it should have superuser privileges.

createuser -interactive

Step 5: create a new database

You have successfully created a new role “Henrique” in the server. Now, let’s create a new database for the user “Henrique”.

By default, the function used to log in has a database of the same name that can be accessed in PostgreSQL. So if you created a new henry database, the henry function will connect to it by default.

You can create a new database using the created command. This command creates a new “henry” database.

created by Henry

run the l command to verify that the new database has been created.

I

Step 6: Open Postgres Shell with new function

A system account with the same username as the role can log in to this role. So if you don’t have a corresponding user with the same name, you’ll need to create one first.

sudo adduser henry

After creating the user, switch to the henry user using the following command.

sudo su – henry

run the psql command to open the Postgres shell as user “henry”.

psql

Then type this command to check the connection details.

conninfo

Step 7: I create Tables in the database

A relational database can contain many related tables. A table has rows and columns. It is useful for storing structured data such as customers, products, employees, etc.

You may use the d command to view tables in a database.

The CREATE TABLE statement creates a new table in the current database. The table owner will be the user executing the command.

The basic syntax of CREATE THE TABLE to create tables is:

CREATE TABLE table_name (column_name1 datatype (length) column_contraint,column_name2 datatype (length) column_contraint,column_name3 datatype (length) column_contraint,);

It will define a new table, column names and types, maximum length and column constraints.

Final Words

We hope you like our article on how to Install PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS Jammy Linux. Regardless of how you use pgAdmin 4, you’ll find that it accepts one or more users with ease and generates a configuration that looks and feels like a desktop application. With improved UI elements, more dashboard and deployment options, and a minimal learning curve, pgAdmin 4 is easy to use.