Postgis extension version for the RDS Preview Postgresql 15

0

What version of the PostGIS extension is available on the RDS Preview Postgresql 15 database.

asked 2 years ago1036 views
2 Answers
0
Accepted Answer

It looks like PostGIS is not an available extension on the Postgresql 15 preview. After creating an instance and getting connecting to it, postgis is not in the list from "SHOW rds.extensions;"

answered 2 years ago
profile picture
EXPERT
reviewed 2 months ago
0

The version of the PostGIS extension available on an Amazon Relational Database Service (RDS) Preview PostgreSQL 15 database depends on the specific RDS instance type and region you are using. You can check the version of PostGIS that is available on your RDS instance by connecting to the database and running the following command:

SELECT postgis_full_version();

This will return the version of PostGIS that is installed on your RDS instance.

Keep in mind that RDS PostgreSQL 15 is currently in preview and may not be available in all regions. If you are using a different version of PostgreSQL on RDS, the version of PostGIS available to you may also be different.

SeanSi
answered 2 years ago
  • I was hoping to avoid setting up an instance in the Preview environment if the PostGIS version has not advanced past what was available for the Postgresql 14 instances, 3.1. Is there some documentation that explains what instance types have what PostGIS versions available? The only preview RDS region I have available is US-East-2 so I don't have any options there. I would like to avoid blindly setting up different instances to connect to and check the PostGIS version of. I need PostGIS version 3.2 or greater.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions