How to Install PostgreSQL and PGAdmin on Ubuntu 24.04 LTS

Learn how to **install PostgreSQL and PGAdmin on Ubuntu 24.04 LTS** step by step. PostgreSQL is a powerful open-source relational database system, and PGAdmin is a feature-rich GUI tool for managing PostgreSQL databases. In this guide, we’ll cover how to set up both tools, configure them, and start using them efficiently.

---

### What You’ll Learn:
1. Installing PostgreSQL on Ubuntu 24.04 LTS.
2. Installing and setting up PGAdmin.
3. Configuring PostgreSQL to work with PGAdmin.

---

### Steps to Install PostgreSQL

#### 1. **Update System Packages**
Keep your system up to date:
```bash
sudo apt update && sudo apt upgrade -y
```

#### 2. **Install PostgreSQL**
Install the PostgreSQL database server:
```bash
sudo apt install postgresql postgresql-contrib -y
```

#### 3. **Start and Enable PostgreSQL**
Ensure the PostgreSQL service is running and enabled at boot:
```bash
sudo systemctl start postgresql
sudo systemctl enable postgresql
```

#### 4. **Switch to PostgreSQL User**
Switch to the default PostgreSQL user to configure the database:
```bash
sudo -i -u postgres
```

#### 5. **Access PostgreSQL Prompt**
Enter the PostgreSQL shell:
```bash
psql
```
- Create a new database user or modify configurations as needed.
- Exit the shell using:
```sql
\q
```

---

### Steps to Install PGAdmin

#### 1. **Install Dependencies**
Install required dependencies:
```bash
sudo apt install curl ca-certificates -y
```

#### 2. **Add the PGAdmin Repository**
Import the repository key and add the PGAdmin repository:
```bash
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/pgadmin.gpg
echo "deb [signed-by=/usr/share/keyrings/pgadmin.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/ubuntu $(lsb_release -cs) pgadmin4" | sudo tee /etc/apt/sources.list.d/pgadmin4.list
```

#### 3. **Install PGAdmin**
Update the package list and install PGAdmin:
```bash
sudo apt update
sudo apt install pgadmin4-web -y
```

#### 4. **Configure PGAdmin**
Run the setup script to configure PGAdmin:
```bash
sudo /usr/pgadmin4/bin/setup-web.sh
```
- Set up an admin email and password for accessing the PGAdmin web interface.

#### 5. **Access PGAdmin**
Open a browser and go to `http://server-ip/pgadmin4` or `http://127.0.0.1/pgadmin4`.
Log in using the admin credentials you set earlier.

---

### Connect PostgreSQL to PGAdmin
1. Open PGAdmin and add a new server.
2. Provide the **name** for the server.
3. Under the **Connection** tab, add:
- Host: `localhost`
- Port: `5432`
- Username: `postgres`
- Password: The password set for the `postgres` user.
4. Save the configuration and start managing your PostgreSQL databases.

---

### Why Use PostgreSQL and PGAdmin?
- **PostgreSQL**: Reliable, feature-rich, and highly extensible database.
- **PGAdmin**: Simplifies database management with a user-friendly GUI.

By following these steps, you’ll have PostgreSQL and PGAdmin installed and ready for use on Ubuntu 24.04 LTS. Like, share, and subscribe for more Linux tutorials!

#PostgreSQL #PGAdmin #Ubuntu24 #DatabaseManagement #LinuxTutorial #PostgresInstall #PGAdminSetup #OpenSourceTools #UbuntuLTS #TechGuide

Видео How to Install PostgreSQL and PGAdmin on Ubuntu 24.04 LTS канала ProgrammingKnowledge2