postgres-ts-vectors

5 Commits

Author	SHA1	Message	Date
maxime.killinger	dcf4169d3d	feat(docker): add PostGIS and remove unstable PG18 support 🚀 Docker Build and Push / build-and-push (16) (push) Successful in 16m11s Details 🚀 Docker Build and Push / build-and-push (15) (push) Successful in 16m26s Details 🚀 Docker Build and Push / build-and-push (17) (push) Successful in 11m7s Details - Install PostGIS (postgresql--postgis-3) in the final image. - Add postgis and postgis_topology to init-extensions.sh. - Add test script for PostGIS to the CI workflow. - Update README.md to reflect PostGIS integration. - Remove PG18 from CI matrix because of ABI incompatibility between TimescaleDB headers and the vchord-postgres PG18 runtime (missing palloc0_mul). PG18 support will be restored when VectorChord releases a stable PG18 image.	2026-08-03 18:14:08 +02:00
maxime.killinger	50d82af527	chore(deps): update TimescaleDB to 2.28.3 and VectorChord to v1.1.1 🚀 Docker Build and Push / build-and-push (15) (push) Successful in 14m53s Details 🚀 Docker Build and Push / build-and-push (16) (push) Successful in 14m55s Details 🚀 Docker Build and Push / build-and-push (17) (push) Successful in 14m39s Details 🚀 Docker Build and Push / build-and-push (18) (push) Failing after 15m10s Details Fixes CRLF line endings in Docker entrypoint scripts.	2026-08-03 17:20:07 +02:00
maxime.killinger	f0d5f4870e	fix(docker): resolve permission denied error for PG18+ volume mounts 🚀 Docker Build and Push / build-and-push (15) (push) Successful in 4m44s Details 🚀 Docker Build and Push / build-and-push (16) (push) Successful in 4m48s Details 🚀 Docker Build and Push / build-and-push (17) (push) Successful in 4m47s Details 🚀 Docker Build and Push / build-and-push (18) (push) Successful in 4m36s Details PostgreSQL 18+ Docker images changed the data directory structure to use versioned subdirectories (e.g., /var/lib/postgresql/18/main) instead of the traditional /var/lib/postgresql/data path. Changes: - Dockerfile: Add mkdir and chown to ensure /var/lib/postgresql has correct permissions for the postgres user before volume mount - README.md: Update Quick Start with volume mount example - README.md: Add 'Data Persistence' section explaining PG18+ requirements This fixes the 'mkdir: cannot create directory: Permission denied' error that occurred when mounting volumes at /var/lib/postgresql. See: https://github.com/docker-library/postgres/pull/1259	2025-12-25 17:32:43 +01:00
maxime.killinger	df585b765a	feat: Add comprehensive test suite and cleanup step 🚀 Docker Build and Push / build-and-push (15) (push) Successful in 5m54s Details 🚀 Docker Build and Push / build-and-push (16) (push) Successful in 6m0s Details 🚀 Docker Build and Push / build-and-push (17) (push) Successful in 5m56s Details 🚀 Docker Build and Push / build-and-push (18) (push) Successful in 6m4s Details - Split validation into 4 granular CI steps (Config, Timescale, Vector, Hybrid) - Added cleanup step for Docker images in CI - Created SQL test scripts in tests/ for robustness	2025-12-19 14:02:36 +01:00
maxime.killinger	4ea4132653	feat: PostgreSQL image with TimescaleDB, VectorChord, pgvector 🚀 Docker Build and Push / build-and-push (15) (push) Successful in 5m44s Details 🚀 Docker Build and Push / build-and-push (16) (push) Successful in 5m33s Details 🚀 Docker Build and Push / build-and-push (18) (push) Successful in 6m7s Details 🚀 Docker Build and Push / build-and-push (17) (push) Successful in 7m54s Details - Multi-stage Dockerfile for optimized image size (676MB vs 2GB) - Support for PostgreSQL 15, 16, 17, 18 - TimescaleDB 2.24.0, VectorChord 1.0.0, pgvector 0.8.1 - Auto-creation of extensions on first startup - CI/CD with tests for all versions - OCI labels and healthcheck included	2025-12-19 12:18:10 +01:00