[postgis-users] Postgis raster question: how to enable raster type in 2.0

[Pierre Racine]

rtpostgis.sql if for loading raster definition and function into the database. Not to upgrade.

http://postgis.net/docs/manual-dev/postgis_installation.html#create_new_db_extensions

http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading

Pierre

> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Ivan Santiago
> Sent: Monday, February 25, 2013 3:22 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Postgis raster question: how to enable raster type in
> 2.0
> 
> 
> 
> Turns out it raster support was installed.  I made another DB without enabling
> postgis extension which includes raster.
> 
> 
> 
> I hope that solves the problem. Still need to load a raster to see if this worked.
> 
> 
> 
> Did you load rtpostgis.sql?
> 
> 
> 
> It looks like rtpostgis.sql is for upgrading postgis. would you recommend me to
> run it?
> 
> 
> 
> we are on version 2.0.2
> 
> 
> 
> ---------------------------
> Iván Santiago
> GIS Specialist
> Information Technologies
> Office of Management and Budget
> <https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.ogp.go
> bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/>
> 787.725.9420 x 2378
> Calle Cruz 254
> PO Box 9023228
> San Juan, PR 00902-3228
> 
> 
> 
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Pierre Racine
> Sent: Monday, February 25, 2013 4:06 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Postgis raster question: how to enable raster type in
> 2.0
> 
> 
> 
> Did you load rtpostgis.sql?
> 
> 
> 
> Pierre
> 
> 
> 
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Ivan Santiago
> Sent: Monday, February 25, 2013 1:42 PM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] Postgis raster question: how to enable raster type in 2.0
> 
> 
> 
> Hello all:
> 
> 
> 
> We installed postgresql 9.2 and postgis 2.0 in a CentOS 5 virtual server.
> 
> 
> 
> after running:
> 
>  select postgis_full_version();
> 
> 
> 
> I get the following:
> 
> 
> 
>  "POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6
> 
>  March 2012" LIBXML="2.7.6" LIBJSON="UNKNOWN""
> 
> 
> 
> Raster does not appear.
> 
> 
> 
> How can I enable raster data type?
> 
> 
> 
> Thanks in advance.
> 
> ---------------------------
> Iván Santiago
> GIS Specialist
> Information Technologies
> Office of Management and Budget
> <https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.ogp.go
> bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/>
> 787.725.9420 x 2378
> Calle Cruz 254
> PO Box 9023228
> San Juan, PR 00902-3228
> 
>