Opened 3 years ago

Closed 3 years ago

#4756 closed defect (wontfix)

PostGIS 3.0.2 is bundled with GDAL 2.4.4 that has ogr2ogr incompatible with PG12

Reported by: mlt Owned by: strk
Priority: medium Milestone: PostGIS 3.0.3
Component: build/upgrade/install Version: 3.0.x
Keywords: ogr2ogr, gdal, windows, win32, packaging Cc:


PostGIS 3.0.2 available for download for PostgreSQL 12 and Windows at has ogr2ogr that is built with GDAL 2.4.4 that is incompatible with PostgreSQL 12. . I presume newer GDAL should be packaged for Windows.

Change History (2)

comment:1 by robe, 3 years ago

Component: postgisbuild/upgrade/install
Owner: changed from pramsey to strk

comment:2 by robe, 3 years ago

Resolution: wontfix
Status: newclosed

mlt I do plan to release the upcoming PostGIS 3.0.3 with GDAL 3.0.4 or GDAL 3.1. However I'm not sure which problem you are having here. I suspect my upgrade won't fix your issue.

The ogr2ogr that is distributed with windows PostGIS Bundle doesn't even have PostgreSQL driver packaged in with it. I did that intentionally because then I'd have possible issues with libpq that is distributed with each PostgreSQL version and I use the same GDAL package across all the PostGIS bundle PostgreSQL versions.

You can verify with below that PostgreSQL is not a supported driver

ogr2ogr --formats

The ogr2ogr is pretty barebones and was there just cause I needed to verify drivers before ogrfdw introduced option to list drivers.

If you need an ogr2ogr that contains postgresql support — I highly recommend using one of Tamas package His is what I use when I need PostgreSQL support or some other non-built in drivers. He also has versions built whenever a change in GDAL.

Alternative would be to use the Foreign Data Wrapper (ogr_fdw) which I find easier to use than fussing with ogr2ogr.

The issue I pointed out in that GDAL ticket doesn't affect the ogr_fdw since ogr_fdw doesn't rely on the PostgreSQL plumbing in GDAL. It has it's own plumbing which is a bit different from postgresql to postgresql.

Note: See TracTickets for help on using tickets.