Pgadmin Linux Ubuntu Install

```html

Install PostgreSQL and pgAdmin on Ubuntu 23.10 Mantic Minotaur x86_64

Requirements

• Ubuntu 23.10 Mantic Minotaur x86_64
• Curl command line utility

How to Install

1. Install Curl Utility

Run the following command to install the curl command line utility:

sudo apt update && sudo apt install curl

2. Add PostgreSQL Repository

Run the following commands to add the PostgreSQL repository:

curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list

3. Update and Install PostgreSQL

Run the following commands to update the package list and install PostgreSQL:

sudo apt update && sudo apt install postgresql postgresql-contrib

4. Create PostgreSQL Database and User

Run the following commands to create a PostgreSQL database and user:

sudo systemctl start postgresql sudo -u postgres psql CREATE DATABASE mydb; CREATE USER myuser WITH PASSWORD 'mypassword'; GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;

5. Install pgAdmin

Run the following commands to install pgAdmin:

sudo apt update sudo apt install pgadmin4

Conclusion

You have successfully installed PostgreSQL and pgAdmin on Ubuntu 23.10 Mantic Minotaur x86_64. You can now start using PostgreSQL and pgAdmin to manage your databases. ```