HUB
Sign inSign up
postgresql logo

turnkeylinux/postgresql

By turnkeylinux

•Updated 1 day ago

PostgreSQL - Advanced Object-relational Database System

Image
0

587

turnkeylinux/postgresql repository overview

⁠TurnKey PostgreSQL on Docker

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.

⁠Start PostgreSQL

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.

⁠Backup and migration

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.

Tag summary

Content type

Image

Digest

Size

328 MB

Last updated

about 8 years ago

docker pull turnkeylinux/postgresql