Сборка Docker образа PostgreSQL с расширениями и прочими примочками
Примеры конфигураций для сборки Docker образа PostgreSQL с расширениями и прочими примочками.
В шаблонную БД установлены расширения:
| Extension | Description |
|---|---|
| adminpack | administrative functions for PostgreSQL |
| amcheck | functions for verifying relation integrity |
| btree_gin | support for indexing common datatypes in GIN |
| citext | data type for case-insensitive character strings |
| dblink | connect to other PostgreSQL databases from within a database |
| file_fdw | foreign-data wrapper for flat file access |
| fuzzystrmatch | determine similarities and distance between strings |
| hunspell_en_us | en_US Hunspell Dictionary |
| hunspell_ru_ru | Russian Hunspell Dictionary |
| hunspell_ru_ru_aot | Russian Hunspell Dictionary (from AOT.ru group) |
| pageinspect | inspect the contents of database pages at a low level |
| pg_buffercache | examine the shared buffer cache |
| pg_dbo_timestamp | PostgreSQL extension for storing time and author of database structure modification |
| pg_prewarm | prewarm relation data |
| pg_repack | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_stat_statements | track execution statistics of all SQL statements executed |
| pg_trgm | text similarity measurement and index searching based on trigrams |
| pg_tsparser | parser for text search |
| pg_variables | session variables with various types |
| pgstattuple | show tuple-level statistics |
| pldbgapi | server-side support for debugging PL/pgSQL functions |
| plpgsql | PL/pgSQL procedural language |
| plpgsql_check | extended check for plpgsql functions |
| plpython3u | PL/Python3U untrusted procedural language |
| postgis | PostGIS geometry, geography, and raster spatial types and functions |
| postgis_tiger_geocoder | PostGIS tiger geocoder and reverse geocoder |
| postgis_topology | PostGIS topology spatial types and functions |
| postgres_fdw | foreign-data wrapper for remote PostgreSQL servers |
| rum | RUM index access method |
| shared_ispell | Provides shared ispell dictionaries. |
| uuid-ossp | generate universally unique identifiers (UUIDs) |
Recommended Posts
Пояснение конфига для Pgbouncer
12.02.2024
Конфигурационный шаблон jinja2 для Patroni
11.02.2024