Install pgAdmin on Ubuntu And connect RDS with pgAdmin

Techpointby — Sat, 06 Sep 2025 06:41:07 +0000

want to use pgAdmin to connect with AWS RDS (PostgreSQL). Let’s do this step by step.

1. Install pgAdmin on Ubuntu

Run these commands in terminal:

# Update system
sudo apt update && sudo apt upgrade -y

# Install curl, wget, gnupg (if missing)
sudo apt install curl wget ca-certificates gnupg -y

# Add pgAdmin repo key
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgadmin.gpg

# Add repo to sources list
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'

# Update repos
sudo apt update

# Install desktop + web version (recommended)
sudo apt install pgadmin4 -y

2. Run pgAdmin

For desktop mode:

pgadmin4

(It opens pgAdmin GUI)

For web mode (browser):

sudo /usr/pgadmin4/bin/setup-web.sh

It will ask you for pgAdmin email + password (used only for login).
After setup, pgAdmin web will run at: 👉 http://127.0.0.1/pgadmin4

3. Connect AWS RDS to pgAdmin

Open pgAdmin (desktop or web).
Right-click Servers → Create → Server.
Enter details:
- Name: AWS RDS
- Host name/address: your RDS endpoint
- (e.g. mydb.c9akciq3lqxy.us-east-1.rds.amazonaws.com)
- Port: 5432
- Username: (the master username you set, e.g. admin)
- Password: (your master password)
- Save.

4. Fix Security Group in AWS

If connection fails:

- Go to AWS Console → RDS → Databases → your DB → Connectivity & security.
- Check VPC security groups.
- Edit inbound rules:

Add rule: PostgreSQL (5432) → My IP (your Ubuntu machine’s public IP).(Find IP with curl ifconfig.me).

5. Test Connection from Ubuntu (Optional)

Before pgAdmin, you can check with psql:

sudo apt install postgresql-client -y

psql -h your-rds-endpoint -U admin -d postgres

It will ask for password → then connect.

✅ Now your Ubuntu + pgAdmin is ready, and you can see AWS RDS database, run queries, manage tables, etc.

Deploy a Dockerized Django App on AWS (EC2 + Nginx + Gunicorn + RDS + S3) — A Beginner-Friendly Guide

Techpointby — Thu, 04 Sep 2025 08:47:03 +0000

This process only for run project on IP Address without domain but it not support other device (like mobile,tablet etc.)

No prior DevOps experience needed—just follow the steps.

Step 0 — Prerequisites

EC2 Ubuntu 22.04 LTS instance with public IP.

Security group allowing:

SSH 22 → your IP

HTTP 80 → 0.0.0.0/0

HTTPS 443 → 0.0.0.0/0 (optional)

Key pair .pem file to SSH in.

Your Django project in GitHub (with Dockerfile).

RDS (PostgreSQL) and S3 bucket ready.

Step 1 — SSH into EC2

Open your Ubuntu terminal open .pem file path where you install

ssfsf@youdsfsdf-sdf-by-lef-Laptop-134-e0xxx:~$ cd Desktop

Importent open path where you download key par .pem file

In EC2 > Instance > Your_intance (click connect button on top right)
Go SSH Client
copy Run this command

ssfsf@youdsfsdf-sdf-by-lef-Laptop-134-e0xxx:~/Desktop$

Past .pem path location

ssfsf@youdsfsdf-sdf-by-lef-Laptop-134-e0xxx:~/Desktop$ chmod 400 "yourpairkey.pem"

Press Enter , then copy Example code SSH Client

ssfsf@youdsfsdf-sdf-by-lef-Laptop-134-e0xxx:~/Desktop$ ssh -i "yourpairkey.pem" ubuntu@ec2-31-85-7123-234.compute-1.amazonaws.com

Then Press Enter, wait few seconds then it ask yes/no type yes it setup ubuntu.

Now your ubuntu live

Step 2 — Update & Install Packages

sudo apt update && sudo apt upgrade -y

# Install required packages
sudo apt install -y git python3-pip python3-venv nginx curl ca-certificates gnupg lsb-release

Step 3 — Install Docker CE & Compose

# Remove any old Docker
sudo apt remove -y docker docker.io docker-engine containerd runc
sudo apt autoremove -y

# Add Docker repo
sudo mkdir -p /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
echo "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null

# Install Docker
sudo apt update
sudo apt install -y docker-ce docker-ce-cli containerd.io docker-compose-plugin

# Start Docker & allow user access
sudo systemctl enable --now docker
sudo usermod -aG docker $USER
newgrp docker

# Test Docker
docker run hello-world

Step 4 — Create virtual environment

python3 -m venv venv

This will create a folder venv/ inside your project.

source venv/bin/activate

Your shell prompt should now show (venv) at the beginning.

Install project dependencies :

pip install --upgrade pip
pip install -r requirements.txt

Step 5 — Clone your project


git clone <YOUR_REPO_URL>

Step 6 — Create .env for secrets

nano .env

In your .env file have allowhost set public IP :

ALLOWED_HOSTS=<EC2_PUBLIC_IP>,localhost,127.0.0.1

Step 7 — Adjust Django settings

Access settings.py page use cmd :

nano settings.py

for save use ctrl + o (is not zero) then Enter , Ctrl+x exit , see changes use cmd:

cat settings.py

CSRF_TRUSTED_ORIGINS = [f"http://{h}" for h in ALLOWED_HOSTS if h not in ("localhost","127.0.0.1")]

# True to False 
CSRF_COOKIE_SECURE = False     
SESSION_COOKIE_SECURE = False

Step 8 — Build Docker image

docker build -t mydjangoapp .

Step 9 — Configure Nginx

Create config:

sudo nano /etc/nginx/sites-available/watchmart.conf

Paste:

server {
    listen 80;
    server_name _;

    location / {
        proxy_pass http://127.0.0.1:8000;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}

Check which site Nginx is serving

ls -l /etc/nginx/sites-enabled/

If you see default -> /etc/nginx/sites-available/default, Nginx is still using the default config.
Your Django config file must be enabled and default should be removed.

Enable your config & disable default :

sudo rm /etc/nginx/sites-enabled/default
sudo ln -s /etc/nginx/sites-available/watchmart.conf /etc/nginx/sites-enabled/

Step 10 — Run Docker container

docker run -d \
  --name mydjangoapp \
  --env-file .env \
  -p 127.0.0.1:8000:8000 \
  --restart always \
  mydjangoapp

Gunicorn runs inside container on port 8000.
Nginx will proxy traffic from port 80 → 8000.

Check logs:

docker logs -f mydjangoapp

Enable and test:

sudo nginx -t
sudo systemctl restart nginx

If you see syntax is ok and test is successful, Nginx is now pointing to your Django container.

Open in browser

Visit:

http://<EC2_PUBLIC_IP>

You should now see your Django app instead of the Nginx default page.

You’re live! 🎉

Follow on :
Git Hub
Instagram
Youtube

DEV Community: Techpointby