Videos relacionados con 22.04

H1 - 22.04

H2 - 22.04

Ver video "H2 - 22.04"

WB 1 - 22.04

Ver video "WB 1 - 22.04"

Explorando Ubuntu 22.04 'Jammy Jellyfish': una distribución sumamente sencilla de utilizar

Hola gente! En este video veremos lo sencillo que es instalar Ubuntu 22.04 "Jammy Jellyfish" y adaptarse a él, haciendo la transición al mundo Linux más accesible que nunca.
--------------------------
Música:

Song: Syn Cole - Need Ya [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: http://NCS.io/NeedYa

Ver video "Explorando Ubuntu 22.04 'Jammy Jellyfish': una distribución sumamente sencilla de utilizar"

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
#### 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!

Ver video "How to Install PostgreSQL and PGAdmin on Ubuntu 24.04 LTS"