Обсуждение: gdal missing support for postgresql on pgdg92 for centos6
Hi, I installed postgresql/postgis2/gdal from the pgdg92 repo for Centos 6, x64 version. I need ogr/gdal to connect to postgresql, however, typing ogrinfo --formats give me these results: Supported Formats: -> "ESRI Shapefile" (read/write) -> "MapInfo File" (read/write) -> "UK .NTF" (readonly) ... -> "PGeo" (readonly) -> "MSSQLSpatial" (read/write) -> "MySQL" (read/write) -> "PCIDSK" (read/write) ... where -> "PostgreSQL" (read/write) is missing. This is my list of installed packages from pgdg92: CGAL.x86_64 4.0.2-1.el6 @pgdg92 armadillo.x86_64 4.300.0-1.rhel6 @pgdg92 compat-libevent14.x86_64 1.4.13-1.rhel6 @pgdg92 compat-slang.x86_64 1.4.9-27.2.2 @pgdg92 gaul-devel.x86_64 0.1849-0 @pgdg92 gdal.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-debuginfo.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-devel.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-doc.noarch 1.9.2-5.rhel6 @pgdg92 gdal-java.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-javadoc.noarch 1.9.2-5.rhel6 @pgdg92 gdal-libs.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-perl.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-python.x86_64 1.9.2-5.rhel6 @pgdg92 gdal-ruby.x86_64 1.9.2-5.rhel6 @pgdg92 geos.x86_64 3.4.2-1.rhel6 @pgdg92 geos-debuginfo.x86_64 3.4.2-1.rhel6 @pgdg92 geos-devel.x86_64 3.4.2-1.rhel6 @pgdg92 geos-python.x86_64 3.4.2-1.rhel6 @pgdg92 gpsbabel.x86_64 1.4.4-1.el6 @pgdg92 libgeotiff.x86_64 1.4.0-1.el6 @pgdg92 libpqxx.x86_64 1:4.0.1-1.rhel6 @pgdg92 pg_top92.x86_64 3.7.0-1.rhel6 @pgdg92 pgrouting_92.x86_64 1.05-1.rhel6 @pgdg92 postgis2_92.x86_64 2.1.7-1.rhel6 @pgdg92 postgis2_92-client.x86_64 2.1.7-1.rhel6 @pgdg92 postgis2_92-debuginfo.x86_64 2.1.7-1.rhel6 @pgdg92 postgis2_92-devel.x86_64 2.1.7-1.rhel6 @pgdg92 postgis2_92-docs.x86_64 2.1.7-1.rhel6 @pgdg92 postgis2_92-utils.x86_64 2.1.7-1.rhel6 @pgdg92 postgresql92.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-contrib.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-debuginfo.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-devel.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-docs.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-jdbc.x86_64 9.2.1002-1PGDG.rhel6 @pgdg92 postgresql92-jdbc-debuginfo.x86_64 9.2.1002-1PGDG.rhel6 @pgdg92 postgresql92-libs.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-odbc.x86_64 09.03.0400-1PGDG.rhel6 @pgdg92 postgresql92-odbc-debuginfo.x86_64 09.03.0400-1PGDG.rhel6 @pgdg92 postgresql92-plperl.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-plpython.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-pltcl.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-server.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 postgresql92-tcl.x86_64 2.0.0-1.rhel6 @pgdg92 postgresql92-tcl-debuginfo.x86_64 2.0.0-1.rhel6 @pgdg92 postgresql92-test.x86_64 9.2.10-1PGDG.rhel6 @pgdg92 proj.x86_64 4.8.0-2.rhel6 @pgdg92 proj-devel.x86_64 4.8.0-2.rhel6 @pgdg92 python-psycopg2.x86_64 2.5.2-1.rhel6 @pgdg92 python-psycopg2-debuginfo.x86_64 2.5.2-1.rhel6 @pgdg92 python-psycopg2-doc.x86_64 2.5.2-1.rhel6 @pgdg92 python-psycopg2-test.x86_64 2.5.2-1.rhel6 @pgdg92 I have another server with everything installed from pgdg93, and ogr has postgresql support built in. However, I cannot upgrade this server to a newer pgsql version. Could you give me any hint on how to debug the issue? Thank you for any help. Regards, Paolo Crosato -- Paolo Crosato
Hi, On Mon, 2015-05-18 at 17:37 +0200, Paolo Crosato wrote: > I installed postgresql/postgis2/gdal from the pgdg92 repo for Centos 6, > x64 version. > I need ogr/gdal to connect to postgresql, however, typing ogrinfo > --formats give me these results: > > Supported Formats: > -> "ESRI Shapefile" (read/write) > -> "MapInfo File" (read/write) > -> "UK .NTF" (readonly) > ... > -> "PGeo" (readonly) > -> "MSSQLSpatial" (read/write) > -> "MySQL" (read/write) > -> "PCIDSK" (read/write) > ... > > where -> "PostgreSQL" (read/write) > is missing. <snip> > I have another server with everything installed from pgdg93, and ogr has > postgresql support built in. However, I cannot upgrade this server to a > newer pgsql version. > > Could you give me any hint on how to debug the issue? It is a packaging issue. I have fixed this in last year in 9.3, but forgot to update 9.2 branch. I am building the new packages now, and will push them soon. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Вложения
Hi, Il 18/05/2015 22:17, Devrim Gündüz ha scritto: > Hi, > > On Mon, 2015-05-18 at 17:37 +0200, Paolo Crosato wrote: > >> I installed postgresql/postgis2/gdal from the pgdg92 repo for Centos 6, >> x64 version. >> I need ogr/gdal to connect to postgresql, however, typing ogrinfo >> --formats give me these results: >> >> Supported Formats: >> -> "ESRI Shapefile" (read/write) >> -> "MapInfo File" (read/write) >> -> "UK .NTF" (readonly) >> ... >> -> "PGeo" (readonly) >> -> "MSSQLSpatial" (read/write) >> -> "MySQL" (read/write) >> -> "PCIDSK" (read/write) >> ... >> >> where -> "PostgreSQL" (read/write) >> is missing. > <snip> > >> I have another server with everything installed from pgdg93, and ogr has >> postgresql support built in. However, I cannot upgrade this server to a >> newer pgsql version. >> >> Could you give me any hint on how to debug the issue? > It is a packaging issue. I have fixed this in last year in 9.3, but > forgot to update 9.2 branch. I am building the new packages now, and > will push them soon. > > Regards, > I tried today an update but it doesn't seem there's any new gdal packaged on http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/, but It doesn't seem there's any new package. Have you got any update on this issue? Regards, Paolo -- Paolo Crosato Software engineer/Custom Solutions e-mail: paolo.crosato@targaubiest.com