[postgis-users] Determine Postgis Raster Usage

[Regina Obe]

Minor typo I meant to say

It is safe to run:

DROP EXTENSION postgis_raster;

Because the drop extension WITHOUT  CASCADE will not allow you to drop the
extension if any data or functions that are not part of the extension depend
on it.

Don't do with CASCADE otherwise you'll be dropping raster columns and
possibly user defined functions and other objects that use raster.

> -----Original Message-----
> From: Regina Obe [mailto:lr at pcorp.us]
> Sent: Tuesday, February 1, 2022 4:24 PM
> To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> Subject: RE: [postgis-users] Determine Postgis Raster Usage
> 
> If you have no raster tables then most likely raster is not used by your
team
> aside from a input/output sort of way.
> 
> If you run this query
> 
> SELECT *
> FROM raster_columns;
> 
> 
> And you get nothing back, you are safe to uninstall raster in 3.0+.
> Even if people are using it, it means they are using it just for in/out
> conversion like they have pictures stored as bytea in db and are using it
to
> resize them.
> 
> These kind of uses, there is no loss in dropping the raster support and
> readding it back because the only danger of dropping raster support is
> dropping raster columns.
> 
> Also note, if you get to the point where you are on PostGIS 3+ and have
> rebundled the raster extension.
> 
> It is safe to run:
> 
> DROP EXTENSION postgis_raster;
> 
> Because the drop extension with CASCADE will not allow you to drop the
> extension if any data or functions that are not part of the extension
depend
> on it.
> 
> 
> 
> 
> 
> 
> > -----Original Message-----
> > From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> > Behalf Of Paul Ramsey
> > Sent: Tuesday, February 1, 2022 11:45 AM
> > To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> > Subject: Re: [postgis-users] Determine Postgis Raster Usage
> >
> > Other than turning on statement logging and parsing for use of raster
> > functions, I do not think so.
> >
> > > On Feb 1, 2022, at 8:00 AM, Nikhil Shetty <nikhil.dba04 at gmail.com>
> > wrote:
> > >
> > > Hi Team,
> > >
> > > Is there a way to confirm if raster is being used by the application
team?
> > > PostGIS version - 2.5.4
> > >
> > > From PostGIS version 3.0, we have to create an extension so we can
> > > know
> > that the raster functions may be used by the application team.
> > >
> > > Thanks,
> > > Nikhil
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users