N
Neon•2w ago
other-emerald

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 and cannot be created with 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 and 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
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...
4 Replies
stormy-gold
stormy-gold•2w ago
Hey! Indeed, I was able to replicate this, so you're not alone. I will forward this to the team. Thank you for reporting and the detailed ticket!
sunny-green
sunny-green•2w ago
Hey @mikee, thanks for reporting! This is likely an issue with our Postgres 18 image (still in public preview and having rough edges). Reported and will keep you updated!
sunny-green
sunny-green•2w ago
Hi @mikee, looks like this is a docs issue on this page - thanks for reporting! We're still porting over extensions to Postgres 18 and PostGIS is currently not yet supported on 18. Will update the docs to reflect this. Sorry about the confusion this caused 🙏
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...
other-emerald
other-emeraldOP•2w ago
Thanks!

Did you find this page helpful?