How to Install PostgreSQL 18 on Ubuntu 24.04 LTS

PostgreSQL (Postgres in short) is an open source, powerful, advanced, high-performance, and stable relational-document database system, which extends the SQL language and includes a wide range of features for secure data storage and management.
Commands:
sudo apt install -y postgresql-common ca-certificates
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt update
sudo apt install postgresql-18 postgresql-contrib-18
sudo apt install -y curl ca-certificates gnupg
curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg
# Install for both desktop and web modes
sudo apt install pgadmin4

# Install for desktop mode only
sudo apt install pgadmin4-desktop

# Install for web mode only
sudo apt install pgadmin4-web

# Configure the webserver, if you installed pgadmin4-web:
sudo /usr/pgadmin4/bin/setup-web.sh
sudo systemctl status postgresql
sudo systemctl enable postgresql
http://127.0.0.1/pgadmin4
Chapters:
0:00 Intro
0:19 How to Install PostgreSQL on Ubuntu 24.04
1:39 Install pgAdmin 4 for PostgreSQL Administration
5:00 End screen
What you will learn:
1. How to Install PostgreSQL on Ubuntu 24.04
a. How to access to newer PostgreSQL versions
b. How to use automated repository configuration script that automatically set up the official PostgreSQL Apt repository
c. How to update the package list and install the latest PostgreSQL (PostgreSQL 18 as of today)
2. Install pgAdmin 4 for PostgreSQL Administration
a. How to manage your PostgreSQL databases using graphical interface
b. How you can install pgAdmin 4
c. How to manage databases, users, queries, and more – all from a web-based dashboard
d. How to use the official pgAdmin repository to download pgAdmin 4
e. How to add pgAdmin repository
f. How you can confirm the status of PostgreSQL
g. How To enable PostgreSQL to start on boot
h. How to open pgAdmin in your browser
i. How to configure the webserver if you install pgadmin4-web
Song: Tinkan - Get Over You
Music provided by Vlog No Copyright Music
Link: https://bit.ly/3YMWwW7

#computereverywhere #PostgreSQL #PostgreSQL18 #Ubuntu2404 #UbuntuLTS #UbuntuServer #LinuxTutorial #DatabaseInstallation #InstallPostgreSQL #PostgresOnUbuntu #OpenSourceDatabase #SQLDatabase #LinuxServer #TechTutorial #SysAdmin #DevOps #Programming #DatabaseSetup #UbuntuTutorial #PostgresSQL #LinuxGuide

Видео How to Install PostgreSQL 18 on Ubuntu 24.04 LTS канала Computer Everywhere