PostgreSQL - Advanced Object-relational Database System
585
Run PostgreSQL with Webmin and Adminer on Linux/amd64. The image includes automatic security updates and can connect to the TurnKey Hub for backup and DNS.
mkdir -p turnkey-postgresql && cd turnkey-postgresql
curl -fL -o compose.postgresql.yaml https://github.com/turnkeylinux/buildtasks/releases/download/library-19.0.3-hotfix/turnkey-postgresql-19.0.3-compose.yaml
docker compose -f compose.postgresql.yaml pull
docker compose -f compose.postgresql.yaml up -d
docker compose -f compose.postgresql.yaml exec postgresql turnkey console
Complete the console setup to set the server root password and PostgreSQL password. Connect to PostgreSQL on localhost:18905, or open Adminer at https://localhost:18903, select PostgreSQL and sign in as postgres with the PostgreSQL password. Your browser will ask you to accept the initial self-signed HTTPS certificate. The Compose file uses turnkeylinux/postgresql:19.0.3, binds its ports to localhost and keeps server data in Docker volumes. See the PostgreSQL overview and Docker guide for more information.
Connect the server to the Hub during setup and enable Hub backup, connecting an AWS account if needed. Then initialize and run a backup:
docker compose -f compose.postgresql.yaml exec postgresql tklbam-init
docker compose -f compose.postgresql.yaml exec postgresql tklbam-backup
Security updates install automatically. Check /var/lib/turnkey-docker/security-updates.json in the container if an update fails. To move to a new image, copy the Compose file, choose unused ports and a distinct project name, then restore the backup to the new server. Keep the original image and volume set until you verify the restored databases.
The TKLBAM guide covers backup settings and restoration.
Content type
Image
Digest
Size
328 MB
Last updated
about 8 years ago
docker pull turnkeylinux/postgresql