Skip to content

payloadcms/postgis-vector

 
 

Repository files navigation

postgis-vector

postgresql,postgis docker container with pgvector added

Build Status

podman pull ghcr.io/payloadcms/postgis-vector:latest

Build

podman build -t postgis-vector .

Minimal Run

podman run -it --name postgis-vector -e POSTGRES_PASSWORD=mysecretpassword -d postgis-vector
podman exec -it postgis-vector bash

##
# To verify extensions installed
##
$ su - postgres
$ psql
postgres=# \dx


                                           List of installed extensions
          name          | default_version | installed_version |                          comment                           
------------------------+-----------------+-------------------+------------------------------------------------------------
 fuzzystrmatch          | 1.2             | 1.2               | determine similarities and distance between strings
 plpgsql                | 1.0             | 1.0               | PL/pgSQL procedural language
 vector                 | 0.8.0           | 0.8.0             | vector data type and ivfflat and hnsw access methods
 postgis                | 3.5.2           | 3.5.2             | PostGIS geometry and geography spatial types and functions
 postgis_topology       | 3.5.2           | 3.5.2             | PostGIS topology spatial types and functions
 postgis_tiger_geocoder | 3.5.2           | 3.5.2             | PostGIS tiger geocoder and reverse geocoder
(6 rows)

##
# To list all available extensions
##
postgres=# select * from pg_available_extensions;

About

Docker image that installs postgresql with postgis and pgvector

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages

  • Dockerfile 80.2%
  • Shell 19.8%