[postgis-users] PostGIS Rasters Overview Factor

David Haynes haynesd2 at gmail.com
Wed May 10 09:12:39 PDT 2017

You are correct overviews are powers based. Also it does not look like you
specified tile size in your raster2pgsql statement

raster2pgsql -s <SRID> -d -Y -e -I -C -F -M -t <pixels> x <pixels> -l

On Wed, May 10, 2017 at 11:04 AM, Osahon Oduware <osahon.gis at gmail.com>

> Hi All,
> I tried loading a raster with overviews using the raster2pgsql tool using
> the syntax below:
> raster2pgsql -s <SRID> -d -Y -e -I -C -F -M -l 2,4,8,16,32,64,128,256,512,
> 1024,2048,4096,8192,16384,32768,65536 /path/to/raster/file <table_name> |
> psql -h <host_address> -U postgres -p 5432 -d <database>
> but it gave an error message stating that the overview factor cannot be
> more than 1,000.
> I would like to know how the Overview-factor works. Must the value for the
> Overview-factor be in Powers of 2 (i.e. 2,4,8,16,...)?
> I would be glad if someone could help my understanding.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170510/5c298b6b/attachment.html>

More information about the postgis-users mailing list