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
and cannot be created with
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.
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
and
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 extensionsSELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';-- Result: (0 rows)-- Attempt to create PostGIS extensionCREATE 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 extensionsSELECT 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 extensionsSELECT * FROM pg_available_extensions WHERE name LIKE '%postgis%';-- Result: (0 rows)-- Attempt to create PostGIS extensionCREATE 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 extensionsSELECT 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 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...