PostGIS Extension Not Available After Multiple Compute Restarts

Issue: PostGIS extension is not available on our Neon database despite multiple compute restarts. The extension does not appear in

pg_available_extensions

pg_available_extensions

pg_available_extensions

pg_available_extensions and cannot be created with

CREATE EXTENSION postgis

CREATE EXTENSION postgis

CREATE EXTENSION postgis

CREATE EXTENSION postgis.

Request: Cannot implement geospatial functionality for our application that requires spatial data types and PostGIS functions. Need guidance on how to enable PostGIS on our Neon database or confirmation if it requires a specific plan.

---

Detailed Information

Database Configuration

- PostgreSQL Version: 18.0 [{ "server_version": "18.0 (3fbcbf1)"}]
- Region: aws-us-east-2
- Plan: Free

Actions Taken

Besides running the"CREATE EXTENSION statement in the Neon SQL Editor, I've also tried restarting the compute:

- Two Compute Restarts: Successfully restarted compute endpoint via API
- API Response:

suspend_compute

suspend_compute

suspend_compute

suspend_compute and

start_compute

start_compute

start_compute

start_compute operations triggered
- Status: Both operations completed successfully

Test Results

After both restarts, PostGIS is still not available:

-- Check for PostGIS in available extensions
SELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';
-- Result: (0 rows)

-- Attempt to create PostGIS extension
CREATE EXTENSION IF NOT EXISTS postgis;
-- Error: extension "postgis" is not available
-- HINT: The extension must first be installed on the system where PostgreSQL is running.

-- Check all spatial/geo-related extensions
SELECT name, default_version, comment FROM pg_available_extensions 
WHERE name ~ '.*(geo|spatial|gis|geom).*' ORDER BY name;
-- Result: Only btree_gist (1.8) - support for indexing common datatypes in GiST

-- Check for PostGIS in available extensions
SELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';
-- Result: (0 rows)

-- Attempt to create PostGIS extension
CREATE EXTENSION IF NOT EXISTS postgis;
-- Error: extension "postgis" is not available
-- HINT: The extension must first be installed on the system where PostgreSQL is running.

-- Check all spatial/geo-related extensions
SELECT name, default_version, comment FROM pg_available_extensions 
WHERE name ~ '.*(geo|spatial|gis|geom).*' ORDER BY name;
-- Result: Only btree_gist (1.8) - support for indexing common datatypes in GiST

-- Check for PostGIS in available extensions
SELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';
-- Result: (0 rows)

-- Attempt to create PostGIS extension
CREATE EXTENSION IF NOT EXISTS postgis;
-- Error: extension "postgis" is not available
-- HINT: The extension must first be installed on the system where PostgreSQL is running.

-- Check all spatial/geo-related extensions
SELECT name, default_version, comment FROM pg_available_extensions 
WHERE name ~ '.*(geo|spatial|gis|geom).*' ORDER BY name;
-- Result: Only btree_gist (1.8) - support for indexing common datatypes in GiST

-- Check for PostGIS in available extensions
SELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';
-- Result: (0 rows)

-- Attempt to create PostGIS extension
CREATE EXTENSION IF NOT EXISTS postgis;
-- Error: extension "postgis" is not available
-- HINT: The extension must first be installed on the system where PostgreSQL is running.

-- Check all spatial/geo-related extensions
SELECT name, default_version, comment FROM pg_available_extensions 
WHERE name ~ '.*(geo|spatial|gis|geom).*' ORDER BY name;
-- Result: Only btree_gist (1.8) - support for indexing common datatypes in GiST

Questions for Support

1. Is PostGIS available on all Neon plans? Or does it require a paid tier?
2. Is the table "Supported Postgres extensions" here accurate? https://neon.com/docs/extensions/pg-extensions
3. Are there any additional steps required beyond compute restart to activate PostGIS?

Neon

Supported Postgres extensions - Neon Docs

Neon supports the Postgres extensions shown in the following table. The supported version of the extension sometimes differs by Postgres version. A dash ( ) indicates that an extension is not yet supp...

PostGIS Extension Not Available After Multiple Compute Restarts

Detailed Information

Database Configuration

Actions Taken

Test Results

Questions for Support

Similar Threads

Similar Threads

Similar Threads