[nicholas.kiraly@bludgeon ~]$ psql -U deployment pg93_postgis21_sig10 psql (9.3.5) Type "help" for help. pg93_postgis21_sig10=# select postgis_full_version(), pg_backend_pid(); NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:115] GDAL_SKIP = "" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:116] enabled_drivers = "(null)" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:174] driver count = 104 CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[0] = "VRT" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[1] = "GTiff" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[2] = "NITF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[3] = "RPFTOC" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[4] = "ECRGTOC" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[5] = "HFA" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[6] = "SAR_CEOS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[7] = "CEOS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[8] = "JAXAPALSAR" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[9] = "GFF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[10] = "ELAS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[11] = "AIG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[12] = "AAIGrid" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[13] = "GRASSASCIIGrid" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[14] = "SDTS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[15] = "DTED" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[16] = "PNG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[17] = "JPEG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[18] = "MEM" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[19] = "JDEM" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[20] = "GIF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[21] = "BIGGIF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[22] = "ESAT" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[23] = "BSB" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[24] = "XPM" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[25] = "BMP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[26] = "DIMAP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[27] = "AirSAR" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[28] = "RS2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[29] = "PCIDSK" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[30] = "PCRaster" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[31] = "ILWIS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[32] = "SGI" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[33] = "SRTMHGT" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[34] = "Leveller" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[35] = "Terragen" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[36] = "ISIS3" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[37] = "ISIS2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[38] = "PDS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[39] = "TIL" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[40] = "ERS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[41] = "L1B" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[42] = "FIT" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[43] = "GRIB" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[44] = "JPEG2000" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[45] = "RMF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[46] = "MSGN" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[47] = "RST" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[48] = "INGR" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[49] = "GSAG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[50] = "GSBG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[51] = "GS7BG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[52] = "COSAR" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[53] = "TSX" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[54] = "COASP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[55] = "R" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[56] = "MAP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[57] = "PNM" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[58] = "DOQ1" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[59] = "DOQ2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[60] = "ENVI" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[61] = "EHdr" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[62] = "GenBin" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[63] = "PAux" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[64] = "MFF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[65] = "MFF2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[66] = "FujiBAS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[67] = "GSC" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[68] = "FAST" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[69] = "BT" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[70] = "LAN" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[71] = "CPG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[72] = "IDA" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[73] = "NDF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[74] = "EIR" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[75] = "DIPEx" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[76] = "LCP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[77] = "GTX" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[78] = "LOSLAS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[79] = "NTv2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[80] = "CTable2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[81] = "ACE2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[82] = "SNODAS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[83] = "KRO" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[84] = "ARG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[85] = "RIK" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[86] = "USGSDEM" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[87] = "GXF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[88] = "NWT_GRD" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[89] = "NWT_GRC" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[90] = "ADRG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[91] = "SRP" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[92] = "BLX" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[93] = "SAGA" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[94] = "KMLSUPEROVERLAY" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[95] = "XYZ" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[96] = "HF2" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[97] = "PDF" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[98] = "OZI" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[99] = "CTG" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[100] = "E00GRID" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[101] = "ZMap" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[102] = "NGSGEOID" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:178] drv_set[103] = "IRIS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:244] gdal_skip = "VRT GTiff NITF RPFTOC ECRGTOC HFA SAR_CEOS CEOS JAXAPALSAR GFF ELAS AIG AAIGrid GRASSASCIIGrid SDTS DTED PNG JPEG MEM JDEM GIF BIGGIF ESAT BSB XPM BMP DIMAP AirSAR RS2 PCIDSK PCRaster ILWIS SGI SRTMHGT Leveller Terragen ISIS3 ISIS2 PDS TIL ERS L1B FIT GRIB JPEG2000 RMF MSGN RST INGR GSAG GSBG GS7BG COSAR TSX COASP R MAP PNM DOQ1 DOQ2 ENVI EHdr GenBin PAux MFF MFF2 FujiBAS GSC FAST BT LAN CPG IDA NDF EIR DIPEx LCP GTX LOSLAS NTv2 CTable2 ACE2 SNODAS KRO ARG RIK USGSDEM GXF NWT_GRD NWT_GRC ADRG SRP BLX SAGA KMLSUPEROVERLAY XYZ HF2 PDF OZI CTG E00GRID ZMap NGSGEOID IRIS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: [rt_pg.c:rtpg_assignHookGDALEnabledDrivers:255] GDAL_SKIP = "VRT GTiff NITF RPFTOC ECRGTOC HFA SAR_CEOS CEOS JAXAPALSAR GFF ELAS AIG AAIGrid GRASSASCIIGrid SDTS DTED PNG JPEG MEM JDEM GIF BIGGIF ESAT BSB XPM BMP DIMAP AirSAR RS2 PCIDSK PCRaster ILWIS SGI SRTMHGT Leveller Terragen ISIS3 ISIS2 PDS TIL ERS L1B FIT GRIB JPEG2000 RMF MSGN RST INGR GSAG GSBG GS7BG COSAR TSX COASP R MAP PNM DOQ1 DOQ2 ENVI EHdr GenBin PAux MFF MFF2 FujiBAS GSC FAST BT LAN CPG IDA NDF EIR DIPEx LCP GTX LOSLAS NTv2 CTable2 ACE2 SNODAS KRO ARG RIK USGSDEM GXF NWT_GRD NWT_GRC ADRG SRP BLX SAGA KMLSUPEROVERLAY XYZ HF2 PDF OZI CTG E00GRID ZMap NGSGEOID IRIS" CONTEXT: SQL statement "SELECT postgis_gdal_version()" PL/pgSQL function postgis_full_version() line 24 at SQL statement NOTICE: Function postgis_topology_scripts_installed() not found. Is topology support enabled and topology.sql installed? postgis_full_version | pg_backend_pid ----------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------- POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.9.2" LIBJSON="UNKNOWN" RASTER | 17213 (1 row) [root@bludgeon ~]# gdb -p 17213 GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "amd64-marcel-freebsd". Attaching to process 17213 /usr/src/gnu/usr.bin/gdb/libgdb/../../../../contrib/gdb/gdb/solib-svr4.c:1444: internal-error: legacy_fetch_link_map_offsets called without legacy link_map support enabled. A problem internal to GDB has been detected, further debugging may prove unreliable. Quit this debugging session? (y or n) n /usr/src/gnu/usr.bin/gdb/libgdb/../../../../contrib/gdb/gdb/solib-svr4.c:1444: internal-error: legacy_fetch_link_map_offsets called without legacy link_map support enabled. A problem internal to GDB has been detected, further debugging may prove unreliable. Create a core file of GDB? (y or n) n Reading symbols from /usr/local/bin/postgres...done. Reading symbols from /usr/local/lib/libintl.so.9...done. Loaded symbols for /usr/local/lib/libintl.so.9 Reading symbols from /usr/local/lib/libxml2.so.2...done. Loaded symbols for /usr/local/lib/libxml2.so.2 Reading symbols from /usr/lib/libssl.so.7...done. Loaded symbols for /usr/lib/libssl.so.7 Reading symbols from /lib/libcrypto.so.7...done. Loaded symbols for /lib/libcrypto.so.7 Reading symbols from /lib/libm.so.5...done. Loaded symbols for /lib/libm.so.5 Reading symbols from /lib/libc.so.7...done. Loaded symbols for /lib/libc.so.7 Reading symbols from /lib/libz.so.6...done. Loaded symbols for /lib/libz.so.6 Reading symbols from /usr/lib/liblzma.so.5...done. Loaded symbols for /usr/lib/liblzma.so.5 Reading symbols from /usr/local/lib/postgresql/plpgsql.so...done. Loaded symbols for /usr/local/lib/postgresql/plpgsql.so Reading symbols from /usr/local/lib/postgresql/postgis-2.1.so...done. Loaded symbols for /usr/local/lib/postgresql/postgis-2.1.so Reading symbols from /usr/local/lib/libgeos_c.so.1...done. Loaded symbols for /usr/local/lib/libgeos_c.so.1 Reading symbols from /usr/local/lib/libproj.so.7...done. Loaded symbols for /usr/local/lib/libproj.so.7 Reading symbols from /usr/local/lib/libjson-c.so.2...done. Loaded symbols for /usr/local/lib/libjson-c.so.2 Reading symbols from /usr/local/lib/libgeos-3.4.2.so...done. Loaded symbols for /usr/local/lib/libgeos-3.4.2.so Reading symbols from /usr/lib/libc++.so.1...done. Loaded symbols for /usr/lib/libc++.so.1 Reading symbols from /lib/libcxxrt.so.1...done. Loaded symbols for /lib/libcxxrt.so.1 Reading symbols from /lib/libgcc_s.so.1...done. Loaded symbols for /lib/libgcc_s.so.1 Reading symbols from /usr/local/lib/postgresql/rtpostgis-2.1.so...done. Loaded symbols for /usr/local/lib/postgresql/rtpostgis-2.1.so Reading symbols from /usr/local/lib/libgdal.so...done. Loaded symbols for /usr/local/lib/libgdal.so Reading symbols from /usr/local/lib/libjasper.so.4...done. Loaded symbols for /usr/local/lib/libjasper.so.4 Reading symbols from /usr/local/lib/libgif.so.5...done. Loaded symbols for /usr/local/lib/libgif.so.5 Reading symbols from /usr/local/lib/libjpeg.so.11...done. Loaded symbols for /usr/local/lib/libjpeg.so.11 Reading symbols from /usr/local/lib/libgeotiff.so.2...done. Loaded symbols for /usr/local/lib/libgeotiff.so.2 Reading symbols from /usr/local/lib/libtiff.so.4...done. Loaded symbols for /usr/local/lib/libtiff.so.4 Reading symbols from /usr/local/lib/libpng15.so.15...done. Loaded symbols for /usr/local/lib/libpng15.so.15 Reading symbols from /usr/lib/librt.so.1...done. Loaded symbols for /usr/lib/librt.so.1 Reading symbols from /lib/libthr.so.3...done. [New Thread 802dd5c00 (LWP 100887/postgres)] Loaded symbols for /lib/libthr.so.3 Reading symbols from /usr/local/lib/libjbig.so.1...done. Loaded symbols for /usr/local/lib/libjbig.so.1 Reading symbols from /libexec/ld-elf.so.1...done. Loaded symbols for /libexec/ld-elf.so.1 [Switching to Thread 802dd5c00 (LWP 100887/postgres)] 0x0000000801ed8f28 in recvfrom () from /lib/libc.so.7 (gdb) c Continuing. pg93_postgis21_sig10=# ANALYZE VERBOSE dat_location_tho; INFO: analyzing "public.dat_location_tho" NOTICE: [gserialized_estimate.c:gserialized_analyze_nd:1739] gserialized_analyze_nd called NOTICE: [gserialized_estimate.c:gserialized_analyze_nd:1746] attribute stat target: 100 NOTICE: [gserialized_estimate.c:gserialized_analyze_nd:1752] minrows: 30000 INFO: "dat_location_tho": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1261] compute_gserialized_stats called NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1262] # sample_rows: 1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1263] estimate of total_rows: 1 NOTICE: [gserialized_estimate.c:nd_box_from_gbox:510] GBOX((0.13297138,-0.7491709,0.64889258),(0.13297139,-0.74917084,0.64889264)) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1364] stats->attr->attstattarget: 100 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1365] target # of histogram cells: 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1375] sample_extent: {"min":[0.132971,-0.749171],"max":[0.132971,-0.749171]} NOTICE: [gserialized_estimate.c:nd_box_array_distribution:744] dimension 0, feature 0: bin 0 to bin 50 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:762] dimension 0: range = 0 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:763] dimension 0: average = 1 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:764] dimension 0: stddev = 0 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:765] dimension 0: stddev_ratio = 0 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:744] dimension 1, feature 0: bin 0 to bin 50 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:762] dimension 1: range = 0 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:763] dimension 1: average = 1 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:764] dimension 1: stddev = 0 NOTICE: [gserialized_estimate.c:nd_box_array_distribution:765] dimension 1: stddev_ratio = 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1467] special case: no axes have variability NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1472] histo_size[d]: 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1472] histo_size[d]: 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1475] histo_cells_new: 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1515] histo_cells: 0 NOTICE: [gserialized_estimate.c:nd_box_overlap:598] nd_box: {"min":[0.132971,-0.749171],"max":[0.132971,-0.749171]} NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1573] feature 0: ibox (0, 0, 0, 0) (-1, -1, 0, 0) NOTICE: [gserialized_estimate.c:nd_stats_value_index:356] bad index at (0, 0) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1613] ratio (1) num_cells (1) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1614] at (0, 0, 0, 0) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1624] histogram_features: 1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1625] sample_rows: 1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1626] table_rows: 1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1663] out: slot 0: kind 0 (STATISTIC_KIND_ND) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1664] out: slot 0: op 0 (InvalidOid) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1665] out: slot 0: numnumbers 0 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1666] out: null fraction: 0.000000=0/1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1667] out: average width: 56 bytes NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1668] out: distinct values: all (no check done) NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1669] out: {"ndims":2,"size":[0,0],"extent":{"min":[0.132971,-0.749171],"max":[0.132971,-0.749171]},"table_features":1,"sample_features":1,"not_null_features":1,"histogram_features":1,"histogram_cells":0,"cells_covered":1} NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1261] compute_gserialized_stats called NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1262] # sample_rows: 1 NOTICE: [gserialized_estimate.c:compute_gserialized_stats_mode:1263] estimate of total_rows: 1 Program received signal SIGBUS, Bus error. 0x000000000060b1d2 in std_fetch_func (stats=0x802e4dc5a, rownum=0, isNull=0x7fffffffca57 "?") at analyze.c:1755 1755 HeapTuple tuple = stats->rows[rownum]; Current language: auto; currently minimal (gdb) bt #0 0x000000000060b1d2 in std_fetch_func (stats=0x802e4dc5a, rownum=0, isNull=0x7fffffffca57 "?") at analyze.c:1755 #1 0x0000000805799917 in compute_gserialized_stats_mode () from /usr/local/lib/postgresql/postgis-2.1.so #2 0x000000000060777f in do_analyze_rel (onerel=0x802db9960, vacstmt=0x802c5dae0, acquirefunc=0x606590 , relpages=1, inh=0 '\0', elevel=17) at analyze.c:527 #3 0x0000000000606515 in analyze_rel (relid=58705, vacstmt=0x802c5dae0, bstrategy=0x802df0038) at analyze.c:267 #4 0x0000000000690f32 in vacuum (vacstmt=0x802c5dae0, relid=0, do_toast=1 '\001', bstrategy=0x802df0038, for_wraparound=0 '\0', isTopLevel=1 '\001') at vacuum.c:254 #5 0x0000000000839cc3 in standard_ProcessUtility (parsetree=0x802c5dae0, queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88, completionTag=0x7fffffffd480 "") at utility.c:639 #6 0x00000000008393eb in ProcessUtility (parsetree=0x802c5dae0, queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88, completionTag=0x7fffffffd480 "") at utility.c:309 #7 0x0000000000838f78 in PortalRunUtility (portal=0x802e13038, utilityStmt=0x802c5dae0, isTopLevel=1 '\001', dest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:1187 #8 0x0000000000837f68 in PortalRunMulti (portal=0x802e13038, isTopLevel=1 '\001', dest=0x802c5de88, altdest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:1318 #9 0x00000000008375bd in PortalRun (portal=0x802e13038, count=9223372036854775807, isTopLevel=1 '\001', dest=0x802c5de88, altdest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:816 #10 0x0000000000832e21 in exec_simple_query (query_string=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;") at postgres.c:1048 #11 0x0000000000832150 in PostgresMain (argc=1, argv=0x802c0c210, dbname=0x802c0c058 "pg93_postgis21_sig10", username=0x802c0c030 "deployment") at postgres.c:4007 #12 0x00000000007b8842 in BackendRun (port=0x802c71200) at postmaster.c:4011 #13 0x00000000007b7e17 in BackendStartup (port=0x802c71200) at postmaster.c:3685 #14 0x00000000007b4090 in ServerLoop () at postmaster.c:1586 #15 0x00000000007b1984 in PostmasterMain (argc=3, argv=0x7fffffffdbe8) at postmaster.c:1253 #16 0x00000000006f912c in main (argc=3, argv=0x7fffffffdbe8) at main.c:226