How to Install Postgres and Pgadmin on Ubuntu 24.04 LTS Linux

 1. Run system update command first :

bash :

sudo apt update

2. Open browser search for : 

 https://www.postgresql.org/

Klik on download --> linux --> ubuntu

https://www.postgresql.org/download/linux/ubuntu/

copy paste berikut lalu enter 

sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc

sudo sh -c 'echo "Types: deb deb-src

URIs: https://apt.postgresql.org/pub/repos/apt

Suites: $(lsb_release -cs)-pgdg

Architectures: amd64

Components: main

Signed-By: /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc" > /etc/apt/sources.list.d/pgdg.sources'

sudo apt update
sudo apt install postgresql-18



setelah seleasi, kembali ke browser, ketik pgadmin.org


lalu cari download --> apt 



due to there is curl, we need to install curl,

bash :

sudo apt install curl




then copy this into the terminal 



curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/keyrings/packages-pgadmin-org.gpg
# Create the repository configuration file:
sudo sh -c 'echo "deb [signed-by=/etc/apt/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'
sudo sh -c 'echo "deb [signed-by=/etc/apt/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'
# Install for desktop mode only:
sudo apt install pgadmin4-desktop



---


masuk ke 





bash :

sudo -u postgres psql


alter user postgres with password 'password';

quit

Tweet