Install PostGIS for AlloyDB Omni

Select a documentation version: 15.7.0 keyboard_arrow_down

• Current (16.8.0)
• 16.8.0
• 16.3.0
• 15.12.0
• 15.7.1
• 15.7.0
• 15.5.5
• 15.5.4
• 15.5.2

AlloyDB Omni does not include the PostGIS extension , but you can manually add it to an existing AlloyDB Omni installation by following the instructions on this page to add support for storing, indexing, and querying geospatial data.

Before you begin

Ensure that you've installed AlloyDB Omni on your system.

Add PostGIS to your AlloyDB Omni installation

To add the PostGIS extension to your AlloyDB Omni installation, follow these steps:

1. Find your installed AlloyDB Omni version labels:

   Docker

   docker  
   run  
   --rm  
   -it  
   google/alloydbomni  
   cat  
   VERSION.txt

   Podman

   podman run --rm -it  google/alloydbomni cat VERSION.txt

   The output is similar to the following:

   AlloyDB Omni version: 15.7.0

   Take note of the AlloyDB Omni version number; you need it in the next step.

2. Set the OMNI_VERSION environment variable:

    OMNI_VERSION 
    = 
    VERSION 
   

   Replace VERSION with the complete database server version from the previous step—for example, 15.7.0 .

3. Create a new AlloyDB Omni container that includes PostGIS:

   Linux

     
    mkdir  
   ~/alloydb-omni-postgis 
     
    tee  
   -a  
   ~/alloydb-omni-postgis/Dockerfile << 
   EOF  
   ARG  
   OMNI_VERSION  
   FROM  
   google/alloydbomni: ${ 
    OMNI_VERSION 
    } 
     
   RUN  
   apt-get  
   update && 
   
     
   apt-get  
   install  
   -y  
   --no-install-recommends  
   
     
   postgresql-15-postgis-3 && 
   
     
   apt-get  
   purge  
   -y  
   --auto-remove && 
   
     
   rm  
   -rf  
   /var/lib/apt/lists/*  
   EOF 
     
     cd 
     
   ~/alloydb-omni-postgis 
     
    sudo  
   docker  
   build  
   --build-arg  
    OMNI_VERSION 
    = 
    $OMNI_VERSION 
     
   --tag  
   google/alloydbomni-with-postgis: $OMNI_VERSION 
     
   . 
   

   macOS

     
    mkdir  
   ~/alloydb-omni-postgis 
     
    tee  
   -a  
   ~/alloydb-omni-postgis/Dockerfile << 
   EOF  
   ARG  
   OMNI_VERSION  
   FROM  
   google/alloydbomni: ${ 
    OMNI_VERSION 
    } 
     
   RUN  
   apt-get  
   update && 
   
     
   apt-get  
   install  
   -y  
   --no-install-recommends  
   
     
   postgresql-15-postgis-3 && 
   
     
   apt-get  
   purge  
   -y  
   --auto-remove && 
   
     
   rm  
   -rf  
   /var/lib/apt/lists/*  
   EOF 
     
     cd 
     
   ~/alloydb-omni-postgis 
     
    sudo  
   docker  
   build  
   --build-arg  
    OMNI_VERSION 
    = 
    $OMNI_VERSION 
     
   --tag  
   google/alloydbomni-with-postgis: $OMNI_VERSION 
     
   . 
   

4. Create a new container with AlloyDB Omni named my-omni-postgis :

   Docker

   docker run --name my-omni-postgis  -e POSTGRES_PASSWORD= NEW_PASSWORD 
   -d google/alloydbomni-with-postgis: OMNI_VERSION 
   

   Podman

   podman run --name my-omni-postgis  -e POSTGRES_PASSWORD= NEW_PASSWORD 
   -d google/alloydbomni-with-postgis: OMNI_VERSION 
   

5. Connect to your database with the PostGIS extension:

   docker exec -it my-omni-postgis psql -h localhost -U postgres

6. Enable PostGIS:

     
     CREATE 
     
    EXTENSION 
     
    IF 
     
    NOT 
     
    EXISTS 
     
    POSTGIS 
    ; 
    
     
     SELECT 
     
    postgis_full_version 
    (); 
    
   

   The output looks similar to the following:

     
     postgres 
    =# 
     
    SELECT 
     
    postgis_full_version 
    (); 
    
     
     postgis_full_version 
    
     
     
    
    
     
     POSTGIS 
    = 
    "3.3.2 4975da8" 
     
    [ 
    EXTENSION 
    ] 
     
    PGSQL 
    = 
    "150" 
     
    GEOS 
    = 
    "3.11.1-CAPI-1.17.1" 
     
    PROJ 
    = 
    "9.1.1" 
     
    LIBXML 
    = 
    "2.9.14" 
     
    LIBJSON 
    = 
    "0.16" 
     
    LIBPROTOBUF 
    = 
    "1.4.1" 
     
    WAGYU 
    = 
    "0.5.0 (Internal)" 
    
     
     ( 
    1 
     
    row 
    )