Ubuntu with 2 Postgres versions installed. Can Upgrade, create Dumps + Basebackups and self heal
1.7K
The Repository can be found here
This is a postgres docker image, that is built to keep your data safe. This image will have two versions of postgres installed, to allow an upgrade between Postgres Versions. The purpose is to make upgrading / restoreing a failed database as easy as possible. This image will reduce the time spent to restore failed databases due to issues with shared Storage or crashed Kubernetes Clusters.
You should set SHARED_BUFFERS and EFFECTIVE_CACHE_SIZE to your needs. You can get more information in the repository under /dev/docker-compose.yaml or /dev/run.sh
A script for the startup-, lifeness and readniessprobe can be found und /usr/local/bin/probe.sh
just install a new postgres image. if within the /postgres volume is a directory with the older version name, the following steps will be done:
These steps will only be executed, if ARCHIVE_MODE is 'on'
on startup, the container will check if the old postgres-database is corrupted. if it is, the following steps will be done:
if this should fail, you can copy the latest dump into the /init directory to restore the database from a dump
every hour a database dump will be created. Dumps that will be stored:
DUMP_STRATEGY: full
- every first day of the Month at 00:00 (for 1 year)
- the first backup of every day (for 30 days)
- The last 24 hours
DUMP_STRATEGY: compact
- the first backup of every day (for 7 days)
- The last 3 hours
DUMP_STRATEGY: minimal
- The last 3 hours
you can move a dump with the format tar to /backup/restore to restore the database from a dump. this can also be used to restore from another database. the dump this image creates is created with the following parameters:
--format=t
BE CAREFUL BECAUSE THIS OPTION WILL ALSO REMOVE EVERY WAL AND THE BASEBACKUP. ONLY USE THIS AS A LAST RESORT OR TO INIT A NEW DATABASE
CRONJOBS
- DUMP_TIME: The time, when a database dump is created. default is every hour.
optional, default: "0 * * * *"- BASEBACKUP_TIME: The time, when a basebackup of the database is created. default is every day.
optional, default: "0 0 * * *"
DATABASE
- POSTGRES_USER: The Postgresql user.
required- POSTGRES_PASSWORD: The user password.
required- POSTGRES_DB: The default database name.
required- POSTGRES_HOST_AUTH_METHOD: the authentication method for external connections.
optional, default: 'md5'
- DUMP_STRATEGY: "full", "compact" or "minimal.
optional, default: full- DATABASE_CHECK_TIME: time in seconds to wait, before the scripts determine the database to be defect.
This value should not be to low or to high, to guarantee the database could try to repair itself, before the restore-from-basebackup will be executed.
optional, default: 45
CONFIG
BASE
- SHARED_BUFFERS: Sets the number of shared memory buffers used by the server.
optional, default: 64MB (the default shared-memory for docker-containers - SHOULD BE INCREASED)- EFFECTIVE_CACHE_SIZE: Sets the planner's assumption about the total size of the data caches.
optional, default: 2GB
ARCHIVING
- ARCHIVE_MODE: Allows archiving of WAL files using archive command.
optional, default: on
this images uses uses archive_command instead of the recommended pg_receivewal to keep switch archiving on / off simple
ZFS_OPTIONS
- ZFS_OPTIONS: if ENV Variable is set to 'on', it will set wal_recycle and wal_init_zero to off, to improve zfs performance.
optional, default: off
Content type
Image
Digest
Size
140 MB
Last updated
over 5 years ago
docker pull evokom/postgres