Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eQHi0-0005ca-I8 for pgsql-pkg-yum@arkaria.postgresql.org; Sat, 16 Dec 2017 19:01:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eQHhy-0001uU-RM for pgsql-pkg-yum@arkaria.postgresql.org; Sat, 16 Dec 2017 19:01:14 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eQHhy-0001uK-Fo for pgsql-pkg-yum@lists.postgresql.org; Sat, 16 Dec 2017 19:01:14 +0000 Received: from mail-io0-x229.google.com ([2607:f8b0:4001:c06::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eQHhp-0003mo-7t for pgsql-pkg-yum@postgresql.org; Sat, 16 Dec 2017 19:01:12 +0000 Received: by mail-io0-x229.google.com with SMTP id d16so5916667iob.4 for ; Sat, 16 Dec 2017 11:01:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=Lfv9+JA5ZW25gHzVY/forXhiudrSvb5xOYadtx9EdgM=; b=LBFe9o3km6pmu7YwiiNTtvP9GqTqysAGGV2YPiZ+XeEBxj+I+oWFDOu/dfNgR5a//u WZV4MYDKgPtIdlJfff3/pCoNvBBEFqP8olZfan5a95I+nKNyYu/9fNRUVU5l+CoYetux 5qtnfMUfORe/4wEifnn7FXE610XYr1rjcLeayPg3NVD7a/Xwr1QMVBUoNmZ30Fi7xbOR xsJutwPEqDYjV8TuP2jYRzUw9/E3ztAiF8Vg37qFt31Nwto2ewyUX36tChw7kYlAS9RT qP9LBiCkuWwcHhfWarFErTwuShuq+NLRVjTljeSCZq2Imm8ukJ1KfeeAgqB+r5sIyz2y F50Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=Lfv9+JA5ZW25gHzVY/forXhiudrSvb5xOYadtx9EdgM=; b=ccjkOfD3hBt8KFZSA7XjTgTRDE8e9dqwkoN8kyXY18OIPvPh2LHSLdLJ4RYjAngQIc N4Nf3sxaE3MYve0X6ACVmOCrGMeQpC+AxLuT+wMRre7EPEK33Mk2CRlwdbnSe6T4fdBS ZGrxXJ53tHFBjF+UquPckNzeVGW6e5MUWXl4NLFuwLYrDk5P90bxYFhcBtMwOzVcW5p4 NOAWAX6+sbF7A0m9ySyTH2uuKSZTHyPR8J7MgHHN+rSn1L7pTlHvoW4RAkN7f4mjWdv+ ZctAyG8+L+EeLw8AW7C5fvjZEgqJsPOd/+lRtwn9OY0+apnGv4E0U+xwoeg7gLosH6sE XgVw== X-Gm-Message-State: AKGB3mKzdwufESUO6x3kp9+JLK5eVAcGqc6AL9tUwuxqfQBpKVgfpAVi Xz47QkrhAZBwU0whxxiM5N0ylg== X-Google-Smtp-Source: ACJfBovTd0Owb4agmH72TWQBPVE0bcAl7/KyKcPHy5VQCWVMvovlm/nuwtvoCnu4tB9+44M/BsaDow== X-Received: by 10.107.78.22 with SMTP id c22mr18086882iob.51.1513450863997; Sat, 16 Dec 2017 11:01:03 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id 72sm725202itg.0.2017.12.16.11.01.03 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 16 Dec 2017 11:01:03 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 4E78A80105E; Sat, 16 Dec 2017 13:01:01 -0600 (CST) Date: Sat, 16 Dec 2017 13:01:01 -0600 From: Justin Pryzby To: Devrim =?iso-8859-1?B?R/xuZPx6?= Cc: pgsql-pkg-yum@postgresql.org Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) Message-ID: <20171216190101.GP18184@telsasoft.com> References: <20171129100319.GA12026@telsasoft.com> <1511950968.5887.14.camel@gunduz.org> <20171207210245.GB14216@telsasoft.com> <20171208193313.GG14216@telsasoft.com> <1513307151.3398.15.camel@gunduz.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1513307151.3398.15.camel@gunduz.org> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote: > > proj > > Please grab this from EPEL: > > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/ For centos6, I think there's an issue with the version of proj in EPEL combined with postgis10_24: [pryzbyj@db ~]$ yum list --showdu proj ... Installed Packages proj.x86_64 4.7.0-1.el6 @epel Available Packages proj.i686 4.7.0-1.el6 epel proj.x86_64 4.7.0-1.el6 epel proj.x86_64 4.8.0-2.rhel6 pgdg96 [pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head BEGIN SET DO CREATE FUNCTION psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:107: ERROR: current transaction is aborted, commands ignored until end of transaction block [pryzbyj@db ~]$ nm -D /usr/lib64/libproj.so.0.6.6 |grep pj_get_spheroid_defn || echo NOT FOUND NOT FOUND proj 4.8 from PGDG96 works ok: [pryzbyj@db ~]$ psql 3rivers -qf /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql && echo OK OK [pryzbyj@db ~]$ sudo yum list --showduplicates postgis24_10{,-client,-utils} libgeotiff gdal-libs libspatialite proj Loaded plugins: etckeeper, fastestmirror, security Loading mirror speeds from cached hostfile * base: mirror.scalabledns.com * epel: mirror.chpc.utah.edu * extras: repos.forethought.net * ius: ord.mirror.rackspace.com * updates: repos.forethought.net Installed Packages gdal-libs.x86_64 1.9.2-8.rhel6 @pgdg10 libgeotiff.x86_64 1.4.0-1.rhel6 @pgdg96 libspatialite.x86_64 2.4.0-0.6.RC4.el6 @epel postgis24_10.x86_64 2.4.2-1.rhel6 @pgdg10 postgis24_10-client.x86_64 2.4.2-1.rhel6 @pgdg10 postgis24_10-utils.x86_64 2.4.2-1.rhel6 @pgdg10 proj.x86_64 4.8.0-2.rhel6 @pgdg96 Available Packages gdal-libs.x86_64 1.9.2-8.rhel6 pgdg10 gdal-libs.x86_64 1.9.2-8.rhel6 pgdg96 libgeotiff.i686 1.2.5-6.el6 epel libgeotiff.x86_64 1.2.5-6.el6 epel libgeotiff.x86_64 1.4.0-1.rhel6 pgdg96 libspatialite.i686 2.4.0-0.6.RC4.el6 epel libspatialite.x86_64 2.4.0-0.6.RC4.el6 epel postgis24_10.x86_64 2.4.1-1.rhel6 pgdg10 postgis24_10.x86_64 2.4.2-1.rhel6 pgdg10 postgis24_10-client.x86_64 2.4.1-1.rhel6 pgdg10 postgis24_10-client.x86_64 2.4.2-1.rhel6 pgdg10 postgis24_10-utils.x86_64 2.4.1-1.rhel6 pgdg10 postgis24_10-utils.x86_64 2.4.2-1.rhel6 pgdg10 proj.i686 4.7.0-1.el6 epel proj.x86_64 4.7.0-1.el6 epel proj.x86_64 4.8.0-2.rhel6 pgdg96 Thanks for your support in this and in building RPMs. Justin