PostgreSQL Container Setup Guide

Setting Up the Environment

First, create a directory for PostgreSQL data persistence:

mkdir ~/pg-pod-data

Creating a Pod

Create a pod that will contain both PostgreSQL and pgAdmin:

podman pod create --name pg-pod -p 9876:80 -p 5432:5432

Adding Containers to the Pod

pgAdmin Container

Add pgAdmin to the pod:

podman run --pod=pg-pod \
  -e 'PGADMIN_DEFAULT_EMAIL=atulya@raj.com' \
  -e 'PGADMIN_DEFAULT_PASSWORD=atulya' \
  --name pgadmin \
  -d dpage/pgadmin4

PostgreSQL Container

Add the PostgreSQL database to the pod:

podman run --pod=pg-pod \
  -v ~/pg-pod-data:/var/lib/postgresql/data:Z \
  -e POSTGRES_PASSWORD=atulya \
  -e POSTGRES_USER=atulya \
  --name db \
  -d postgres

Accessing Services

• pgAdmin: Access at localhost:9876
• PostgreSQL: Connect at localhost:5432
  • Server name: localhost
  • Host: localhost

Database Backup

To create a backup of your database:

pg_dump -h ep-restless-bar-a73s.neon.tech \
  -p 5432 \
  -U globalDB_owner \
  -d globalDB \
  -f dummy1.sql

Backup Parameters Explained:

• -h: Host address
• -p: Port number
• -U: Username
• -d: Database name
• -f: Output filename