❗For better reliability we release images with stability tags (wodby/postgres:16-X.X.X) which correspond to git tags. We strongly recommend using images only with stability tags.
Overview:
- All images based on Alpine Linux
- Base image: postgres
- GitHub actions builds
- Docker Hub
Supported tags and respective Dockerfile links:
17,latest(Dockerfile)16(Dockerfile)15(Dockerfile)14(Dockerfile)13(Dockerfile)
All images built for linux/amd64 and linux/arm64
| Variable | Default Value | Description |
|---|---|---|
POSTGRES_CHECKPOINT_COMPLETION_TARGET |
0.7 |
|
POSTGRES_CHECKPOINT_SEGMENTS |
32 |
<=9.4 |
POSTGRES_DATESTYLE |
iso, mdy |
|
POSTGRES_DB |
postgres |
|
POSTGRES_DEFAULT_STATISTICS_TARGET |
100 |
|
POSTGRES_DEFAULT_TEXT_SEARCH_CONFIG |
pg_catalog.english |
|
POSTGRES_EFFECTIVE_CACHE_SIZE |
1GB |
|
POSTGRES_DB_EXTENSIONS |
Separated by comma | |
POSTGRES_LC_MESSAGES |
en_US.utf8 |
|
POSTGRES_LC_MONETARY |
en_US.utf8 |
|
POSTGRES_LC_NUMERIC |
en_US.utf8 |
|
POSTGRES_LC_TIME |
en_US.utf8 |
|
POSTGRES_LOG_TIMEZONE |
UTC |
|
POSTGRES_MAINTENANCE_WORK_MEM |
128MB |
|
POSTGRES_MAX_CONNECTIONS |
100 |
|
POSTGRES_MAX_WAL_SIZE |
2GB |
>=9.5 |
POSTGRES_MIN_WAL_SIZE |
1GB |
>=9.5 |
POSTGRES_SHARED_BUFFERS |
512MB |
|
POSTGRES_SHARED_MEMORY_TYPE |
posix |
>=9.4 |
POSTGRES_TIMEZONE |
UTC |
|
POSTGRES_PASSWORD |
REQUIRED | |
POSTGRES_USER |
postgres |
|
POSTGRES_WAL_BUFFERS |
16MB |
|
POSTGRES_WORK_MEM |
5MB |
Usage:
make COMMAND [params ...]
commands:
import source=</path/to/dump.zip or http://example.com/url/to/dump.sql.gz> [user password db host binary]
backup filepath=</path/to/backup.sql.gz> [user password host db ignore=<"table1;table2"> nice ionice]
query query=<SELECT 1> [user password db host]
query-silent query=<SELECT 1> [user password db host]
check-ready [user password db host max_try wait_seconds delay_seconds]
default params values:
user $POSTGRES_USER
password $POSTGRES_PASSWORD
db $POSTGRES_DB
host localhost
max_try 1
wait_seconds 1
delay_seconds 0
ignore ""
binary 0
nice 10
ionice 7
Deploy PostgreSQL to your server via Wodby.