huggla/postgres-alpine repository overview

Deprecated, use huggla/sam-postgres instead. https://hub.docker.com/repository/docker/huggla/sam-postgres⁠

⁠postgres-alpine

A small and secure Docker image of Postgresql with Pgagent and tds_fdw extensions included. Separate tags with Postgis and/or Plpython3, 3DCityDB extensions available. Will execute .sh and .sql files located in /initdb when a new datastore is created.

20181204: Postgresql 11.1, Pgagent extension 4.0, tds_fdw 2.0.0-alpha.2+, Freetds 1.00.109, Alpine edge.

postgis-20181204: Postgis 2.5.0.

3dcity-20181204: 3DCity 4.0.1, Postgis 2.5.0.

20190129-20190220: Postgresql 11.1, Pgagent extension 4.0, tds_fdw 2.0.0-alpha.3+, Freetds 1.00.111, Alpine edge.

postgis-20190129->20190220: Postgis 2.5.1.

3dcitydb-20190129->20190220: 3DCityDB 4.0.1, Postgis 2.5.1.

⁠Environment variables

⁠pre-set runtime variables

• VAR_CONFIG_FILE="/etc/postgres/postgresql.conf"
• VAR_FINAL_COMMAND="/usr/local/bin/postgres --config_file="$VAR_CONFIG_FILE""
• VAR_LOCALE="en_US.UTF-8"
• VAR_ENCODING="UTF8"
• VAR_TEXT_SEARCH_CONFIG="english"
• VAR_HBA="local all all trust, host all all 127.0.0.1/32 trust, host all all ::1/128 trust, host all all all md5"
• VAR_CREATE_EXTENSION_PGAGENT="yes"
• VAR_ARGON2_PARAMS="-r" (only used if VAR_ENCRYPT_PW is set to "yes")
• VAR_SALT_FILE="/proc/sys/kernel/hostname" (only used if VAR_ENCRYPT_PW is set to "yes")
• VAR_LINUX_USER="postgres" (also database owner/superuser)
• VAR_param_data_directory="'/pgdata'" (Must be owned by UID 102)
• VAR_param_hba_file="'/etc/postgres/pg_hba.conf'"
• VAR_param_ident_file="'/etc/postgres/pg_ident.conf'"
• VAR_param_unix_socket_directories="'/var/run/postgresql'"
• VAR_param_listen_addresses="'*'"
• VAR_param_timezone="'UTC'"
• VAR_FREETDS_CONF="[global]\ntds version=auto\ntext size=64512" (contents of /etc/freerds.conf)
• VAR_SRID="4326" (only for 3dcitydb)
• VAR_SRSNAME="urn:ogc:def:crs:EPSG::4326" (only for 3dcitydb)

⁠Optional runtime variables

• VAR_param_<postgres parameter name>
• VAR_password_file_<VAR_LINUX_USER>
• VAR_password_<VAR_LINUX_USER>
• VAR_ENCRYPT_PW (set to "yes" to hash password with Argon2)

⁠Capabilities

Can drop all but SETPCAP, SETGID and SETUID.

⁠Tips

Works with huggla/pgagent-alpine, huggla/pgadmin-alpine, huggla/pgbouncer-alpine and huggla/postgres-backup.