nhost/postgres

By nhost

Updated about 15 hours ago

Postgres image used by Nhost (http://www.nhost.io)

Image
Databases & Storage

100K+

postgres

Plugins

nameversioncomment
address_standardizer3.5.2Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us3.5.2Address Standardizer US dataset example
amcheck1.4functions for verifying relation integrity
autoinc1.0functions for autoincrementing fields
bloom1.0bloom access method - signature file based index
btree_gin1.3support for indexing common datatypes in GIN
btree_gist1.7support for indexing common datatypes in GiST
citext1.6data type for case-insensitive character strings
cube1.5data type for multidimensional cubes
dblink1.2connect to other PostgreSQL databases from within a database
dict_int1.0text search dictionary template for integers
dict_xsyn1.0text search dictionary template for extended synonym processing
earthdistance1.1calculate great-circle distances on the surface of the Earth
file_fdw1.0foreign-data wrapper for flat file access
fuzzystrmatch1.2determine similarities and distance between strings
hstore1.8data type for storing sets of (key, value) pairs
http1.6HTTP client for PostgreSQL, allows web page retrieval inside the database.
hypopg1.4.1Hypothetical indexes for PostgreSQL
insert_username1.0functions for tracking who changed a table
intagg1.1integer aggregator and enumerator (obsolete)
intarray1.5functions, operators, and index support for 1-D arrays of integers
ip4r2.4
isn1.2data types for international product numbering standards
lo1.1Large Object maintenance
ltree1.3data type for hierarchical tree-like structures
moddatetime1.0functions for tracking last modification time
pageinspect1.12inspect the contents of database pages at a low level
pg_buffercache1.5examine the shared buffer cache
pg_cron1.6Job scheduler for PostgreSQL
pg_freespacemap1.2examine the free space map (FSM)
pg_hashids1.3pg_hashids
pg_ivm1.9incremental view maintenance on PostgreSQL
pg_jsonschema0.3.3pg_jsonschema
pg_prewarm1.2prewarm relation data
pg_repack1.5.2Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze1.8A tool to remove unused space from a relation.
pg_stat_statements1.11track planning and execution statistics of all SQL statements executed
pg_surgery1.0extension to perform surgery on a damaged relation
pg_trgm1.6text similarity measurement and index searching based on trigrams
pg_visibility1.2examine the visibility map (VM) and page-level visibility info
pg_walinspect1.1functions to inspect contents of PostgreSQL Write-Ahead Log
pgcrypto1.3cryptographic functions
pgmq1.5.0A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgrowlocks1.2show row-level locking information
pgstattuple1.5show tuple-level statistics
plpgsql1.0PL/pgSQL procedural language
postgis3.5.2PostGIS geometry and geography spatial types and functions
postgis_raster3.5.2PostGIS raster types and functions
postgis_tiger_geocoder3.5.2PostGIS tiger geocoder and reverse geocoder
postgis_topology3.5.2PostGIS topology spatial types and functions
postgres_fdw1.1foreign-data wrapper for remote PostgreSQL servers
refint1.0functions for implementing referential integrity (obsolete)
seg1.4data type for representing line segments or floating-point intervals
sslinfo1.2information about SSL certificates
tablefunc1.0functions that manipulate whole tables, including crosstab
tcn1.0Triggered change notifications
timescaledb2.18.0Enables scalable inserts and complex queries for time-series data
tsm_system_rows1.0TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time1.0TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent1.1text search dictionary that removes accents
uuid-ossp1.1generate universally unique identifiers (UUIDs)
vector0.8.0vector data type and ivfflat and hnsw access methods
xml21.1XPath querying and XSLT

Options

Following env vars are available in the image (to be set in an Nhost cloud project via settings):

MAX_CONNECTIONS=100
SHARED_BUFFERS=128MB
EFFECTIVE_CACHE_SIZE=4GB
MAINTENANCE_WORK_MEM=64MB
CHECKPOINT_COMPLETION_TARGET=0.9
WAL_BUFFERS=-1
DEFAULT_STATISTICS_TARGET=100
RANDOM_PAGE_COST=4.0
EFFECTIVE_IO_CONCURRENCY=1
WORK_MEM=4MB
HUGE_PAGES=try
MIN_WAL_SIZE=80MB
MAX_WAL_SIZE=1GB
MAX_WORKER_PROCESSES=8
MAX_PARALLEL_WORKERS_PER_GATHER=2
MAX_PARALLEL_WORKERS=8
MAX_PARALLEL_MAINTENANCE_WORKERS=2
JIT=on
WAL_LEVEL=replica
MAX_WAL_SENDERS=10
MAX_REPLICATION_SLOTS=10

CHANGELOG

{14.15,15.10,16.6,17.2}-20250131-1
  • Added support for postgres 17.2
  • Updated postgres to 14.15, 15.10, 16.6
  • Updated extensions:
    • address_standardizer: 3.5.0 → 3.5.2
    • address_standardizer_data_us: 3.5.0 → 3.5.2
    • amcheck: 1.3 → 1.4
    • btree_gist: 1.6 → 1.7
    • fuzzystrmatch: 1.1 → 1.2
    • ltree: 1.2 → 1.3
    • pageinspect: 1.9 → 1.12
    • pg_buffercache: 1.3 → 1.5
    • pg_repack: 1.5.1 → 1.5.2
    • pg_squeeze: 1.7 → 1.8
    • pg_stat_statements: 1.9 → 1.11
    • pgmq: 1.4.5 → 1.5.0
    • postgis: 3.5.0 → 3.5.2
    • postgis_raster: 3.5.0 → 3.5.2
    • postgis_tiger_geocoder: 3.5.0 → 3.5.2
    • postgis_topology: 3.5.0 → 3.5.2
    • timescaledb: 2.17.2 → 2.18.0
{14.13,15.8,16.4}-20250120-1
  • fix: added pg_squeeze to shared_preload_libraries
{14.13,15.8,16.4}-20250117-1
  • Refresh collation version on startup
  • Added pgmq extension
{14.13,15.8,16.4}-20250108-1
  • Added pg_jsonschema extension
{14.13,15.8,16.4}-20241126-1
  • Added pg_repack extension
  • Updated pgvector to 0.8.0
  • Updated timescaledb to 2.17.2
  • Updated postgis to 3.5.0
  • Updated pg_squeeze to 1.7
{14.13,15.8,16.4}-20240930-1
  • Added ip4r extension
{14.13,15.8,16.4}-20240918-1
  • Added pg_ivm plugin
{14.13,15.8,16.4}-20240909-1
  • Bump versions to 14.13, 15.8, 16.4
  • fix: update timescaledb on startup if necessary
{14.11,15.6,16.2}-20240901-1
  • Added pg_hashids plugin
  • Added pg_squeeze plugin
  • Updated pgvector to 0.7.4
  • Updated timescaledb to 2.14.2
  • Update hypopg to 1.4.1
{14.11,15.6,16.2}-20240717-1
  • change default locales to UTF-8
{14.11,15.6,16.2}-20240515-1
  • first multi-version image
14.11-20240515-1
  • Build improvements to support multiple major versions
14.11-20240429-1
  • Upgraded postgres to 14.11
14.6-20240422-1
  • set search_path to public for auth/storage users
14.6-20240412-1
  • amend permissions for auth/storage users so they can trigger events
  • update pgvector to 0.6.2
  • update timescaledb to 2.14.2
  • update postgis to 3.4.2
14.6-20240129-1
  • clean core dumps automatically
14.6-20231218-1
  • Added wal settings
  • plugins: upgraded to following versions:
    • postgis: 3.4.1
14.6-20231031-1
  • plugins: upgraded to following versions:
    • pgvector: 0.5.1
    • cron: 1.6.2
    • timescaldb: 2.12.2
14.6-20231018-1
  • cloud: minor internal improvements
  • plugins: added pgsql-http plugin

Docker Pull Command

docker pull nhost/postgres