🏔️ Alpine - Postgres

PostgreSQL for Docker

SYNOPSIS

What can I do with this? This image will run postgres as postgres with the database postgres and the password you set initially. Why so simple? Because 99.9% of all containers that need postgres, are happy with the default settings, no different dbname, different dbuser, whatever needed. It also adds a simple backup command to backup the entire database.

VOLUMES

• /postgres/etc - Directory of config files
• /postgres/var - Directory of database files
• /postgres/sql - Directory of SQL scripts which will be executed once and then deleted!
• /postgres/backup - Directory of backups

COMPOSE

name: "postgres"
services:
  postgres:
    image: "11notes/postgres:16"
    container_name: "postgres"
    environment:
      TZ: "Europe/Zurich"
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    ports:
      - "5432:5432/tcp"
    volumes:
      - "etc:/postgres/etc"
      - "var:/postgres/var"
      - "sql:/postgres/sql"
      - "backup:/postgres/backup"
    restart: "always"
volumes:
  etc:
  var:
  sql:
  backup:

To take a full backup simply run

docker exec postgres backup

DEFAULT SETTINGS

ENVIRONMENT

SOURCE

• 11notes/postgres:16⁠

PARENT IMAGE

• 11notes/alpine:stable

BUILT WITH

• postgres⁠
• alpine⁠

TIPS

• Use a reverse proxy like Traefik, Nginx to terminate TLS with a valid certificate
• Use Let’s Encrypt certificates to protect your SSL endpoints

ElevenNotes^™️

This image is provided to you at your own risk. Always make backups before updating an image to a new version. Check the changelog for breaking changes. You can find all my repositories on github⁠.