Supabase PostgreSQL Image

supabase/postgres
- Docker 镜像
- 使用 ansible 构建
- ~250MB - 300MB
- 包含大多插件
- 版本号匹配 Postgres
- 基础镜像为 postgres
- Dockerfile
扩展
- supabase/supautils

目前有 PG 15, 17
- 有 PG 17 orioledb 镜像 hub.docker.com/r/supabase/postgres/tags
Vote for Postgres extensions supabase#679

bash

# 注意 superuser 为 supabase_admin 密码和 postgres 相同
# 建议登录为 supabase_admin 然后 alter user postgres with superuser
# https://hub.docker.com/r/supabase/postgres
PASSWORD=$(uuidgen | tr -d '[[:space:]]')
docker run --rm -it \
  -e POSTGRES_PASSWORD=$PASSWORD \
  -p 5432:5432 \
  -e POSTGRES_INITDB_ARGS="--encoding=UTF-8 --lc-collate=C --lc-ctype=C" \
  -v $PWD/data:/var/lib/postgresql/data \
  --name postgres supabase/postgres:17.4.1.071 \
  -clisten_addresses="*" \
  -cshared_preload_libraries=pg_stat_statements,pg_stat_monitor,pgaudit,plpgsql,plpgsql_check,pg_cron,pg_net,timescaledb,auto_explain,pg_tle

ini

unix_socket_directories = '/var/run/postgresql'
session_preload_libraries = 'supautils'
include = '/etc/postgresql-custom/supautils.conf'
cron.database_name = 'postgres'
pljava.libjvm_location = '/usr/lib/jvm/java-11-openjdk-${TARGETARCH}/lib/server/libjvm.so'
pgsodium.getkey_script= '/usr/lib/postgresql/${postgresql_major}/bin/pgsodium_getkey.sh'
auto_explain.log_min_duration = 10s

Extensions

Extension	Description
Postgres contrib modules	`pg_stat_statements`
PostGIS	GIS
pgRouting	Extension of PostGIS - provides geospatial routing functionalities.
pgTAP	Unit Testing for Postgres.
pg_cron	Run CRON jobs inside Postgres.
pgAudit	Generate highly compliant audit logs.
pgjwt	Generate JSON Web Tokens (JWT) in Postgres.
pgsql-http	HTTP client for Postgres.
plpgsql_check	Linter tool for PL/pgSQL.
pg-safeupdate	Protect your data from accidental updates or deletes.
wal2json	JSON output plugin for logical replication decoding.
PL/Java	PL/Java
plv8	PL/Javascript
pg_plan_filter	Only allow statements that fulfill set criteria to be executed.
pg_net	Expose the SQL interface for async networking.
rum	An alternative to the GIN index.
pg_hashids	Generate unique identifiers from numbers.
pgsodium	libsodium
pg_stat_monitor	Query Performance Monitoring
pgvector	vector similarity search
pg_repack	Tool to remove bloat from tables and indexes
pg_jsonschema
pg_graphql
sfcgal
timescaledb
vault
wrappers	FDW dev kit by Supabase
pgroonga
hypopg
pg_tle	trusted language extensions
supautils
plls	PL/LiveScript

sql

create extension if not exists pg_hashids;
-- id_encode, id_decode
select id_encode(1234567, 'This is my salt', /*min length*/ 10, /* alphabet */ 'abcdefghijABCDxFGHIJ1234567890');

TLE - Trusted Language Extensions
tensorchord/pgvecto.rs
- pgvecto.rs #895
  - 不是 trusted extension, 使用了 ipc/mmap
- vs pgvector docs.pgvecto.rs/faqs/comparison-pgvector.html

FAQ

You might want to create it and/or set "pgsodium.getkey_script" to the correct path.

text

pgsodium.getkey_script='/usr/lib/postgresql/${postgresql_major}/bin/pgsodium_getkey.sh'

Extensions

FAQ

You might want to create it and/or set "pgsodium.getkey_script" to the correct path.

关联信息

反向链接

参考资料