[postgis-tickets] [PostGIS] #2359: raster2pgsql - large collection of examples of different bugs in -l (overviews)

[PostGIS]

#2359: raster2pgsql - large collection of examples of different bugs in -l
(overviews)
---------------------+------------------------------------------------------
  Reporter:  gbell   |       Owner:  dustymugs             
      Type:  defect  |      Status:  reopened              
  Priority:  medium  |   Milestone:  PostGIS 2.0.4         
 Component:  raster  |     Version:  2.0.x                 
Resolution:          |    Keywords:  raster2pgsql overviews
---------------------+------------------------------------------------------

Comment(by dustymugs):

 Take two due to bad formatting...

 I've tested for the glibc issue on Fedora 18 updated with the latest
 packages. PostgreSQL 9.2.4, PROJ.4.8.0, GEOS -trunk r3823, GDAL -trunk
 r26081 and PostGIS 2.0.4dev r11543 compiled from source.

 {{{
 [root at localhost temp]# ../bin/raster2pgsql -t 100x100 -I -C -M
 ilatlon_float.tif -Y -l 4 public.bogota | ../bin/psql -U postgres -d test
 }}}

 Running the above repeatedly as per Item #7 results in no glibc stack
 trace.

 Fedora info
 {{{
 [root at localhost temp]# cat /etc/fedora-release
 Fedora release 18 (Spherical Cow)
 }}}

 Installed glibc info
 {{{
 [root at localhost temp]# yum info glibc
 Loaded plugins: langpacks, presto, refresh-packagekit
 Installed Packages
 Name        : glibc
 Arch        : x86_64
 Version     : 2.16
 Release     : 31.fc18
 Size        : 13 M
 Repo        : installed
 From repo   : updates
 Summary     : The GNU libc libraries
 URL         : http://www.gnu.org/software/glibc/
 License     : LGPLv2+ and LGPLv2+ with exceptions and GPLv2+
 Description : The glibc package contains standard libraries which are used
 by
             : multiple programs on the system. In order to save disk space
 and
             : memory, as well as to make upgrading easier, common system
 code is
             : kept in one place and shared between programs. This
 particular
             : package contains the most important sets of shared
 libraries: the
             : standard C library and the standard math library. Without
 these
             : two libraries, a Linux system will not function.
 }}}

 PostgreSQL and PostGIS info

 {{{
 [root at localhost temp]# ../bin/psql -U postgres -d test -c "SELECT
 version(), postgis_full_version()"
 NOTICE:  Function postgis_topology_scripts_installed() not found. Is
 topology support enabled and topology.sql installed?
                                                    version
                               |
                   postgis_full_version

 --------------------------------------------------------------------------------
 ------------------------------+-------------------------------------------------
 --------------------------------------------------------------------------------
 --------------------------
  PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.7.2
 20121
 109 (Red Hat 4.7.2-8), 64-bit | POSTGIS="2.0.4SVN r11543" GEOS="3.4.0dev-
 CAPI-1.
 8.0 r3823" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11dev, released
 2013/04/
 13" LIBXML="2.9.1" RASTER
 (1 row)
 }}}

 I'd suggest upgrading your packages and trying again. There may be issues
 with what config flags you're using when compiling the various programs.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2359#comment:12>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.