Re: PostGIS Out-DB Raster Not Behaving As Expected

Hi Robert,

Thanks, I have done so and the issue has been resolved.

On Tue, Apr 11, 2017 at 2:56 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Mon, Apr 10, 2017 at 10:51 PM, Osahon Oduware <osahon(dot)gis(at)gmail(dot)com>
> wrote:
> > I created an out-db raster using the following syntax:
> >
> > raster2pgsql -s {srid} -c -R -I -C -F -t auto {absolute_file_path}
> > public.{table} | psql -h {host} -p {port} -d {database} -U {user}
> >
> > The table was created successfully. I wanted to confirm that the actual
> file
> > is being read from the location in the filesystem by performing the
> > following steps:
> > 1) I moved the raster file to a different location.
> > 2) I opened QGIS and attempted to load the raster from PostGIS table.
> >
> > I was surprised that QGIS could load the file. How is this possible when
> the
> > actual raster data is not stored in the database table?
>
> You probably want to post this to a PostGIS mailing list, rather than
> a PostgreSQL mailing list, since this question is PostGIS-specific.
> Probably, you want a list for user questions, rather than a list like
> this one which is for development of the product itself. I think this
> may be the right one:
>
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>