[postgis-users] Determine Postgis Raster Usage

[Regina Obe]

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