Is it possible to use SFCGAL backend in AWS RDS PostgreSQL?

Question

Upon trying `CREATE EXTENSION postgis_sfcgal;`, I got the following error:

"ERROR:  Could not open extension control file "/rdsdbbin/postgres-15.4.R1/share/extension/postgis_sfcgal.control": No such file or directory.extension "postgis_sfcgal" is not available "

If not, is there any plan to support this capability?

My goal was to use the PostGIS function ST_ApproximateMedialAxis() (https://postgis.net/docs/ST_ApproximateMedialAxis.html) to extract centered lines from polygons

Answer

Hello.

Please check the following document for extensions supported by RDS PostgreSQL.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.html

I think PostGIS itself can be used.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.PostGIS.html

I don't think it is currently possible to use SFCGAL with RDS.  
https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html

So, although I am not sure if it will be supported, it might be a good idea to send a request to "rds-postgres-extensions-request@amazon.com".  
https://aws.amazon.com/rds/postgresql/faqs/?nc1=h_ls  
> Q: What are the extensions supported by RDS for PostgreSQL?  
You can check the list of supported extensions in the Amazon RDS User Guide. To request support for additional extensions, you can send an email to rds-postgres-extensions-request@amazon.com with the extension name and use case.

Is it possible to use SFCGAL backend in AWS RDS PostgreSQL?

Relevant content