pgAdmin 4 in PostgreSQL – A Beginner’s Guide 🚀

pgAdmin 4 is a GUI tool for managing PostgreSQL databases. It allows you to create, modify, and query databases visually.

1. Install pgAdmin 4

Windows (Recommended)

1. Download the installer from pgAdmin official website.
2. Run the installer and follow the setup instructions.
3. After installation, launch pgAdmin 4 from the Start menu.

Ubuntu/Debian (Linux)

sudo apt updatesudo apt install pgadmin4

macOS (Using Homebrew)

brew install --cask pgadmin4

Docker (Alternative)

docker run -p 5050:80 -e PGADMIN_DEFAULT_EMAIL=admin@example.com -e PGADMIN_DEFAULT_PASSWORD=admin -d dpage/pgadmin4

Access pgAdmin 4 in your browser at http://localhost:5050.

2. Open pgAdmin 4 & Connect to PostgreSQL

1. Launch pgAdmin 4
2. Click on "Add New Server"
3. Enter the connection details:
   • Name: PostgreSQL (or any name)
   • Host: localhost (or your remote server IP)
   • Port: 5432 (default)
   • Username: postgres
   • Password: (Enter your PostgreSQL password)
4. Click Save, and your database should appear in the left panel.

3. Create a Database Using pgAdmin

1. Right-click on Databases → Create → Database
2. Enter a name (e.g., mydb)
3. Click Save

4. Create a Table Using pgAdmin

1. Expand Databases → mydb → Schemas → public
2. Right-click Tables → Create → Table
3. Enter a table name (users)
4. Click on Columns → Add Column:
   • Name: id, Type: SERIAL, Primary Key
   • Name: name, Type: VARCHAR(100)
   • Name: email, Type: VARCHAR(150) (Unique)
5. Click Save

5. Insert Data Using pgAdmin

1. Right-click on users → Query Tool
2. Run the SQL query:

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com'),       ('Bob', 'bob@example.com');

3. Click Execute (▶️ button)

6. Query Data in pgAdmin

1. Open Query Tool
2. Run the query:

SELECT * FROM users;

3. Click Execute (▶️ button)

7. Backup & Restore Databases in pgAdmin

Backup

1. Right-click on the database mydb → Backup
2. Choose a location and format (.backup)
3. Click Start

Restore

1. Right-click on Databases → Create → Database (if not exists)
2. Right-click on the database → Restore
3. Select the .backup file and click Restore

8. Manage Remote PostgreSQL Servers in pgAdmin

If you want to connect to a remote PostgreSQL server, follow these steps:

On the Remote Server

1. Edit postgresql.conf

   sudo nano /etc/postgresql/15/main/postgresql.conf
   

   Change:

   listen_addresses = '*'
   

2. Edit pg_hba.conf

   sudo nano /etc/postgresql/15/main/pg_hba.conf
   

   Add:

   host all all 0.0.0.0/0 md5
   

3. Restart PostgreSQL:

   sudo systemctl restart postgresql
   

On pgAdmin 4

1. Add New Server
2. Use the remote IP address instead of localhost
3. Save and connect

9. Common Errors & Fixes

10. Next Steps

✅ Integrate PostgreSQL with Go Fiber
✅ Learn advanced SQL (Joins, Views, Indexing, Transactions)
✅ Automate database tasks using pgAgent