[postgis-users] error: type "raster" does not exist

[Sandro Santilli]

On Mon, Jan 13, 2020 at 05:54:50PM -0800, john polo wrote:

> error: type "raster" does not exist
> 
> Searching for some help, I came across the note from
> https://postgis.net/docs/manual-3.0/raster.html

[...]

> SELECT postgis_full_version();

[...]

> POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 "
> PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.9.9" LIBJSON="0.12"
> LIBPROTOBUF="1.2.1" WAGYU="0.4.3 (Internal)"

It looks like you did not load postgis_raster extension (required
since version 3.0.0 of PostGIS:

  CREATE EXTENSION postgis_raster;

Happy mapping !

--strk;