postgresql docker compose

• create docker-compose.yml

services:	  db:		image: postgres:16             # Use the PostgreSQL image (version 16)		container_name: my_postgres		restart: always		environment:		  POSTGRES_USER: sap       # PostgreSQL username		  POSTGRES_PASSWORD: sap123ok   # PostgreSQL password		  POSTGRES_DB: mydb           # Default database		ports:		  - "5432:5432"               # Map container port 5432 to host		volumes:		  - pgdata:/var/lib/postgresql/data  # Persist data	volumes:	  pgdata:

• ufw allow 5432/tcp
• ufw reload
• ufw status

backup postgresql

pg_dump -U sap -h localhost mydb > mydb_backup.sql