Install PostGIS for AlloyDB Omni

Preview

This product or feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA products and features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

For information about access to this release, see the access request page.

Select a documentation version: 17.5.0

• Current (17.5.0)
• 17.5.0

This page describes how to manually add the PostGIS extension to an existing AlloyDB Omni installation. The PostGIS extension enables storing, indexing, and querying geospatial data.

Before you begin

Install 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. Request access to the Preview release by submitting this form.

2. Initialize Red Hat Subscription Manager on the VM where you installed the AlloyDB Omni server:

   sudo dnf install -y subscription-manager
   sudo subscription-manager register --username "RHSM_USER" --password "RHSM_PASS" --auto-attach --force
   

   Replace the following:

   • RHSM_USER: the Red Hat Subscription Manager user.
   • RHSM_PASS: the Red Hat Subscription Manager password.

3. Enable CodeReady Builder repository:

   sudo subscription-manager repos --enable="codeready-builder-for-rhel-9-$ARCH-rpms"
   

   Replace ARCH with the RHEL architecture you want to use, for example, x86_64.

4. Add the PostgreSQL Yum Repository:

   sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
   

5. Install PostgreSQL server and development packages:

   sudo dnf install -y "postgresql17-server"
   

   Replace OMNI_VERSION with the AlloyDB Omni version number, which is 17.

6. Install the PostGIS extension:

   sudo dnf install -y postgis35_17
   

7. Create required symlinks so the extensions are in the expected paths:

   set -e
   PGVER="17"
   
   sudo mkdir -p "/usr/lib/postgresql/${PGVER}/share/extension"
   
   for file in /usr/pgsql-${PGVER}/share/extension/*; do
       target="/usr/lib/postgresql/${PGVER}/share/extension/$(basename "$file")"
       if [[ ! -e "$target" ]]; then
         sudo ln -s "$file" "$target" || (echo "Failed to link \"$file\" to \"$target\", exiting." && exit 1)
         echo "Created extension link for $(basename "$file")"
       else
         echo "Target $target already exists."
       fi
   done
   
   sudo mkdir -p "/usr/lib/postgresql/${PGVER}/lib"
   
   for file in /usr/pgsql-${PGVER}/lib/*; do
       target="/usr/lib/postgresql/${PGVER}/lib/$(basename "$file")"
       if [[ ! -e "$target" ]]; then
         sudo ln -s "$file" "$target" || (echo "Failed to link \"$file\" to \"$target\", exiting." && exit 1)
         echo "Created lib link for $(basename "$file")"
       else
         echo "Target $target already exists."
       fi
     fi
   done
   

8. Connect to your database with the PostGIS extension:

   /usr/lib/postgresql/17/bin/psql -h localhost -U postgres
   

9. Enable PostGIS:

   CREATE EXTENSION IF NOT EXISTS POSTGIS;
   

10. Confirm that PostGIS is installed and enabled:

    SELECT postgis_full_version();
    

    The output is 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)