mirror of
https://github.com/appwrite/appwrite.git
synced 2026-05-26 13:51:13 +00:00
Jake Barnby
b952bf7978
The Postgres adapter in utopia-php/database requires PostGIS, pgvector, and pg_trgm extensions. The plain postgres:18 image lacked these, causing "collation utf8_ci_ai does not exist" errors (CREATE EXTENSION failed before the collation could be created). Switch to postgres:17 with a custom Dockerfile that installs the required extensions, matching the approach used by utopia-php/database's own tests. Also reverts the volume mount to /var/lib/postgresql/data (correct for v17). Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
12 lines
352 B
Docker
12 lines
352 B
Docker
ARG POSTGRES_VERSION=17
|
|
FROM postgres:${POSTGRES_VERSION}
|
|
|
|
ARG POSTGRES_VERSION=17
|
|
|
|
RUN apt-get update \
|
|
&& apt-get install -y --no-install-recommends \
|
|
postgresql-${POSTGRES_VERSION}-postgis-3 \
|
|
postgresql-${POSTGRES_VERSION}-postgis-3-scripts \
|
|
postgresql-${POSTGRES_VERSION}-pgvector \
|
|
&& rm -rf /var/lib/apt/lists/*
|