How to install PostgreSQL and PGAdmin on Ubuntu 22.04

Step 8: To install the public key for the repository ,copy the following command and run it.

root@linuxhelp:~# curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg
root@linuxhelp:~# 

Step 9: Create the repository configuration file using the below command

root@linuxhelp:~# sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
Hit:1 http://security.ubuntu.com/ubuntu jammy-security InRelease
Hit:2 http://in.archive.ubuntu.com/ubuntu jammy InRelease                 
Hit:3 http://in.archive.ubuntu.com/ubuntu jammy-updates InRelease                                
Hit:4 http://in.archive.ubuntu.com/ubuntu jammy-backports InRelease                              
Get:5 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4 InRelease [4,217 B]    
Get:6 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4/main all Packages [3,104 B]
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
343 packages can be upgraded. Run 'apt list --upgradable' to see them.
N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease' doesn't support architecture 'i386'

Step 10: Install pgAdmin by using the below command

root@linuxhelp:~# sudo apt install pgadmin4
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libflashrom1 libftdi1-2 libllvm13
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
  apache2 apache2-bin apache2-data apache2-utils libapache2-mod-wsgi-py3 libapr1 libaprutil1
  libaprutil1-dbd-sqlite3 libaprutil1-ldap pgadmin4-desktop pgadmin4-server pgadmin4-web
Suggested packages:
  apache2-doc apache2-suexec-pristine | apache2-suexec-custom
Need to get 220 MB of archives.
After this operation, 8,028 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://in.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libapr1 amd64 1.7.0-8ubuntu0.22.04.1 [108 kB]
Get:2 http://in.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libaprutil1 amd64 1.6.1-5ubuntu4.22.04.2 [92.8 kB]
Get:3 http://in.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libaprutil1-dbd-sqlite3 amd64 1.6.1-5ubuntu4.22.04.2 [11.3 kB]
 Setting up libaprutil1:amd64 (1.6.1-5ubuntu4.22.04.2) ...
Enabling module env.
Enabling module mime.
Enabling site 000-default.
Created symlink /etc/systemd/system/multi-user.target.wants/apache2.service → /lib/systemd/system/apache2.service.
Created symlink /etc/systemd/system/multi-user.target.wants/apache-htcacheclean.service →  
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu3) ...
Processing triggers for man-db (2.10.2-1) ...

Step 11 : Switch to the postgresql user using the below command

root@linuxhelp:~# sudo -u postgres psql
could not change directory to "/root": Permission denied
psql (14.12 (Ubuntu 14.12-0ubuntu0.22.04.1))

Step 12: Alter the postgresql password using the below command

postgres=# alter user postgres with password '123456';
ALTER ROLE

Step 13: Exit from the postgresql user using the below command

postgres=# quit
root@linuxhelp:~# 

Conclusion:

We have reached the end of this article. In this guide, we have walked you through the steps required to installation of PostgreSQL and PgAdmin on Ubuntu 22.04. Your feedback is much welcome.