clover/postgres

By clover

•Updated 4 months ago

PostGRE SQL

Image

5.0K

Overview Tags

clover/postgres repository overview

⁠PostGRE SQL docker image

The world's most advanced open source object-relational database system

This image is based on official postgresql package for Ubuntu and is built on top of clover/common⁠.

⁠Enviroment variables

Name	Default value	Description
`PUID`	not set	desired user id of the process owner
`PGID`	not set	desired group id of the process pwner (primary group of the `PUID` user)
`PUSER`	not set	desired `PUID` user name
`PGROUP`	not set	desired `PGID` group name
`CHOWN`	not set	space-separated list of directories to change ownership to `PUID`/`PGID` during container startup
`CRON`	not set (`0`)	will start cron inside the container if set to `1`
`TZ` / `TIMEZONE`	not set (`UTC`)	desired container timezone
`PGDATA`	`/var/lib/postgresql`	location for the database cluster (data directory)
`POSTGRES_INITDB_AUTH`	not set	default authentication method for local connections
`POSTGRES_INITDB_AUTH_HOST`	`md5` (<=`17`), `scram-sha-256` (=`17`)	default authentication method for local TCP/IP connections
`POSTGRES_INITDB_AUTH_LOCAL`	`trust`	default authentication method for local-socket connections
`POSTGRES_INITDB_ENCODING`	not set (`UTF8`)	default encoding for new databases
`POSTGRES_INITDB_ALLOW_GROUP_ACCESS`	not set (`0`)	allow group read/execute on data directory
`POSTGRES_INITDB_ICU_LOCALE` (>=15)	not set	ICU locale for new databases
`POSTGRES_INITDB_ICU_RULES` (>=16)	not set	additional ICU collation rules for new databases
`POSTGRES_INITDB_LOCALE`	not set (`C.UTF-8`)	default locale for new databases
`POSTGRES_INITDB_LC_COLLATE`	not set	default locale for collate category
`POSTGRES_INITDB_LC_CTYPE`	not set	default locale for ctype category
`POSTGRES_INITDB_LC_MESSAGES`	not set	default locale for messages category
`POSTGRES_INITDB_LC_MONETARY`	not set	default locale for monetary category
`POSTGRES_INITDB_LC_NUMERIC`	not set	default locale for numeric category
`POSTGRES_INITDB_LC_TIME`	not set	default locale for time category
`POSTGRES_INITDB_BUILTIN_LOCALE` (>=`17`)	not set	builtin locale name for new databases
`POSTGRES_INITDB_LOCALE_PROVIDER` (>=`15`)	not set	default locale provider for new databases (`libc`
`POSTGRES_INITDB_PWFILE`	`/etc/postgresql/pwfile`	password file for the new superuser
`POSTGRES_INITDB_TEXT_SEARCH_CONFIG`	not set (`english`)	default text search configuration
`POSTGRES_INITDB_USERNAME`	`postgres`	database superuser name
`POSTGRES_INITDB_WALDIR`	not set (`{PGDATA}/pg_wal/`)	location for the write-ahead log directory
`POSTGRES_INITDB_WAL_SEGSIZE`	not set	size of WAL segments (in megabytes)
`POSTGRES_INITDB_OPTIONS`	not set	space separated list of default settings for server parameters in `KEY=VALUE` format
`POSTGRES_INITDB_DEBUG`	not set	generate lots of debugging output
`POSTGRES_INITDB_DISCARD_CACHES`	not set	set `debug_discard_caches=1`
`POSTGRES_INITDB_DATA_CHECKSUMS`	not set	use data page checksums
`POSTGRES_INITDB_SAMPLE_DIR`	not set (`/usr/share/postgresql/{version}`)	where to find the input files
`POSTGRES_INITDB_NO_CLEAN`	not set	do not clean up after errors
`POSTGRES_INITDB_NO_SYNC`	not set	do not wait for changes to be written safely to disk
`POSTGRES_INITDB_NO_SYNC_DATA_FILES` (>=`17`)	not set	do not sync files within database directories
`POSTGRES_INITDB_NO_INSTRUCTIONS` (>=`14`)	`1`	do not print instructions for next steps
`POSTGRES_INITDB_SYNC_METHOD` (>=`17`)	not set	set method for syncing files to disk (`fsync`
`POSTGRES_SHARED_BUFFERS`	not set	number of shared buffers
`POSTGRES_OPTIONS`	not set	space separated list of runtime server parameters in `KEY=VALUE` format
`POSTGRES_DEBUG_LEVEL`	not set	debugging level (`1` .. `5`)
`POSTGRES_EUROPIAN_DATE`	not set	use European date input format (`DMY`)
`POSTGRES_NO_FSYNC`	not set	turn fsync off
`POSTGRES_LISTEN_HOST`	`*`	host name or IP address to listen on
`POSTGRES_TCP`	not set	enable TCP/IP connections (deprecated)
`POSTGRES_SOCKET_DIR`	not set	Unix-domain socket location
`POSTGRES_SSL`	not set	enable SSL connections
`POSTGRES_MAX_CONNECT`	`128`	maximum number of allowed connections
`POSTGRES_LISTEN_PORT`	`5432`	port number to listen on
`POSTGRES_STATS`	not set	show statistics after each query
`POSTGRES_WORK_MEM`	not set	set amount of memory for sorts (in kilobytes)
`POSTGRES_FORBID_PLAN_TYPES` (>=`14`)	not set	forbid use of some plan types [`siobtnmh`] **
`POSTGRES_NO_SHM_REINIT` (>=`14`)	not set
`POSTGRES_NO_SYS_TABLE_PROTECTION` (>=`14`)	not set	allow system table structure changes
`POSTGRES_NO_SYS_INDEXES` (>=`14`)	not set	disable system indexes
`POSTGRES_QUERY_STATS` (>=`14`)	not set	show timings after each query (`pa`
`POSTGRES_STOP_BACKENDS` (>=`14`)	not set	send `SIGSTOP` (<=`16`) / `SIGABRT` (>=`17`) to all backend processes if one dies
`POSTGRES_WAIT_SEC` (>=`14`)	not set	wait NUM seconds to allow attach from a debugger

⁠* `POSTGRES_INITDB_SYNC_METHOD` (>=`17`) - set method for syncing files to disk

One of the following:

fsync - write normally, then fsync() (default)
fdatasync - write normally, then fdatasync()
open_sync - open file with O_SYNC
open_datasync - open file with O_DSYNC

⁠** `POSTGRES_FORBID_PLAN_TYPES` (>=`14`) - forbid use of some plan types

Any combination of the following:

s - sequential scan
i - index scan
o - index-only scan
b - bitmap index scan
t - tuple ID scan
n - nested loop joins
m - merge joins
h - hash joins

⁠*** `POSTGRES_QUERY_STATS` (>=`14`) - show timings after each query

One of the following:

pa - parse/plan/execution timing (aggregate-style reporting)
pl - per-phase (parse + plan + execution breakdown)
ex - execution-only timing

⁠Supported platforms

linux/amd64;
linux/arm64/v8;
linux/ppc64le;

Tag summary

Recent tags

Content type

Image

Digest

sha256:5ffdbb8d3…

Size

42.7 MB

Last updated

4 months ago

docker pull clover/postgres