Search code examples
postgresqlgoogle-cloud-platformpostgisgoogle-cloud-sqlraster

Is it possible to use postgis_raster extension in CloudSQL?

I'm trying to import a postgreSQL database of rasters to CloudSQL in order to do raster analysis on them from the cloud. I'm trying

CREATE EXTENSION postgis_raster;

but getting the following error

ERROR:  could not open extension control file "/share/extension/postgis_raster.control": No such file or 
directory

I'm assuming that there just isn't any support for postgis_raster on CloudSQL, but I can't find any specific information on it. For now I guess I'll just convert my rasters to point shapefiles. Any help would be appreciated.

Solution

  • You are right about postgis_raster. Still, there is an Extension support: postgis_raster in the Public Issue Tracker. You may follow related developments in that thread.