Upgrading to current version of PostGIS

[Mike Toews]

Hi,

I'm using PostGIS on an Ubuntu Hardy 8.04 LTS server, and I've been using the FDO PostGIS providers with AutoCAD Map 3D 2008 and 2010 (FDO 3.2 and 3.4, respectively) from http://www.geomapgis.com/web/geomap-group/fdo/

Previously, I was using postgis version 1.3.3 / geos 2.2.3 via apt-get
http://packages.ubuntu.com/hardy/postgresql-8.3-postgis
With that setup, my postgis_full_version() SQL command returned:
POSTGIS="1.3.3" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

However, I required an upgrade due to bugs with that version of PostGIS and/or geos (namely ST_Buffer). So, I uninstalled the apt-get builds of proj, geos and postgis packages, and manually built proj, geos, and postgis from source using the current stable versions. Now my postgis_full_version() returns:
POSTGIS="1.3.6" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

The database functions normally, and QGIS can connect, ST_Buffer works, etc. However, I cannot connect or use the database as I did before the upgrade with the PostGIS provider. When attempting to connect, Map3D 2008 crashes with an error "AutoCAD cannot continue" an no other message. Map3D 2010 doesn't crash, but throws an error/exception "There was a problem accessing the connection's schema information."

So, my question is if the version of PostGIS is important to the FDO provider, and if so, what versions are supported? This doesn't have a ticket, but I'll start one once I know a bit more info about the versions.

Thanks,

-Mike
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[doggybs]

Hi Mike

I have had similar problems in the past, which i resolved by making sure that the postgres binaries for the matching postgres server version are present on the client machine, and added the windows environment variables 'path'.

You may also want to use dependency walker (http://www.dependencywalker.com/) on the postgis provider dll, to make sure it is referencing the postgres binary dll for matching server version, an example dll would be libpq.dll.

Hope this helps

James

Mike Toews wrote:

Hi,

I'm using PostGIS on an Ubuntu Hardy 8.04 LTS server, and I've been using the FDO PostGIS providers with AutoCAD Map 3D 2008 and 2010 (FDO 3.2 and 3.4, respectively) from http://www.geomapgis.com/web/geomap-group/fdo/

Previously, I was using postgis version 1.3.3 / geos 2.2.3 via apt-get
http://packages.ubuntu.com/hardy/postgresql-8.3-postgis
With that setup, my postgis_full_version() SQL command returned:
POSTGIS="1.3.3" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

However, I required an upgrade due to bugs with that version of PostGIS and/or geos (namely ST_Buffer). So, I uninstalled the apt-get builds of proj, geos and postgis packages, and manually built proj, geos, and postgis from source using the current stable versions. Now my postgis_full_version() returns:
POSTGIS="1.3.6" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

The database functions normally, and QGIS can connect, ST_Buffer works, etc. However, I cannot connect or use the database as I did before the upgrade with the PostGIS provider. When attempting to connect, Map3D 2008 crashes with an error "AutoCAD cannot continue" an no other message. Map3D 2010 doesn't crash, but throws an error/exception "There was a problem accessing the connection's schema information."

So, my question is if the version of PostGIS is important to the FDO provider, and if so, what versions are supported? This doesn't have a ticket, but I'll start one once I know a bit more info about the versions.

Thanks,

-Mike
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[Mike Toews]

Ok,

So I did some quick unit testing using different versions of PostGIS on our Ubuntu server described below, and here are my results:
 * postgis-1.3.3 (2008/04/12) - works with FDO
 * postgis-1.3.4 (2008/11/24) - works with FDO
 * postgis-1.3.5 (2008/12/15) - doesn't work with FDO
 * postgis-1.3.6 (2009/05/04) - doesn't work with FDO

Note, that I used the same current version of proj and geos for each.

I'm not sure if anyone cares to confirm these results. Basically, my workflow was:

wget http://postgis.refractions.net/download/postgis-1.3.4.tar.gz
tar xfvz postgis-1.3.4.tar.gz
cd postgis-1.3.4/
./configure
make
sudo make install
psql -U postgres -f /usr/share/lwpostgis_upgrade.sql mypostgisdb

# test connecting to PostGIS provider via AutoCAD Map3D

If Crash:
  sudo make uninstall
  # and then repeat from top with a different version of PostGIS

I'm doing fine now with AutoCAD Map3D 2008 and 2010 with:
POSTGIS="1.3.4" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

I've also filed a ticket to support the newer versions:
https://trac.osgeo.org/fdo/ticket/530

-Mike

----- Original Message -----
From: "Michael Toews" <[hidden email]>
To: "FDO Users Mail List" <[hidden email]>
Sent: Thursday, 4 June, 2009 12:32:48 GMT -08:00 US/Canada Pacific
Subject: [fdo-users] Upgrading to current version of PostGIS

Hi,

I'm using PostGIS on an Ubuntu Hardy 8.04 LTS server, and I've been using the FDO PostGIS providers with AutoCAD Map 3D 2008 and 2010 (FDO 3.2 and 3.4, respectively) from http://www.geomapgis.com/web/geomap-group/fdo/

Previously, I was using postgis version 1.3.3 / geos 2.2.3 via apt-get
http://packages.ubuntu.com/hardy/postgresql-8.3-postgis
With that setup, my postgis_full_version() SQL command returned:
POSTGIS="1.3.3" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

However, I required an upgrade due to bugs with that version of PostGIS and/or geos (namely ST_Buffer). So, I uninstalled the apt-get builds of proj, geos and postgis packages, and manually built proj, geos, and postgis from source using the current stable versions. Now my postgis_full_version() returns:
POSTGIS="1.3.6" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

The database functions normally, and QGIS can connect, ST_Buffer works, etc. However, I cannot connect or use the database as I did before the upgrade with the PostGIS provider. When attempting to connect, Map3D 2008 crashes with an error "AutoCAD cannot continue" an no other message. Map3D 2010 doesn't crash, but throws an error/exception "There was a problem accessing the connection's schema information."

So, my question is if the version of PostGIS is important to the FDO provider, and if so, what versions are supported? This doesn't have a ticket, but I'll start one once I know a bit more info about the versions.

Thanks,

-Mike
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[doggybs]

I am successfully using Map and Mapguide 2010 with postgis-1.3.6. Only difference is my postgres server is running on a windows server.

James

Mike Toews wrote:

Ok,

So I did some quick unit testing using different versions of PostGIS on our Ubuntu server described below, and here are my results:
 * postgis-1.3.3 (2008/04/12) - works with FDO
 * postgis-1.3.4 (2008/11/24) - works with FDO
 * postgis-1.3.5 (2008/12/15) - doesn't work with FDO
 * postgis-1.3.6 (2009/05/04) - doesn't work with FDO

Note, that I used the same current version of proj and geos for each.

I'm not sure if anyone cares to confirm these results. Basically, my workflow was:

wget http://postgis.refractions.net/download/postgis-1.3.4.tar.gz
tar xfvz postgis-1.3.4.tar.gz
cd postgis-1.3.4/
./configure
make
sudo make install
psql -U postgres -f /usr/share/lwpostgis_upgrade.sql mypostgisdb

# test connecting to PostGIS provider via AutoCAD Map3D

If Crash:
  sudo make uninstall
  # and then repeat from top with a different version of PostGIS

I'm doing fine now with AutoCAD Map3D 2008 and 2010 with:
POSTGIS="1.3.4" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

I've also filed a ticket to support the newer versions:
https://trac.osgeo.org/fdo/ticket/530

-Mike

----- Original Message -----
From: "Michael Toews" <[e-mail]>
To: "FDO Users Mail List" <[e-mail]>
Sent: Thursday, 4 June, 2009 12:32:48 GMT -08:00 US/Canada Pacific
Subject: [fdo-users] Upgrading to current version of PostGIS

Hi,

I'm using PostGIS on an Ubuntu Hardy 8.04 LTS server, and I've been using the FDO PostGIS providers with AutoCAD Map 3D 2008 and 2010 (FDO 3.2 and 3.4, respectively) from http://www.geomapgis.com/web/geomap-group/fdo/

Previously, I was using postgis version 1.3.3 / geos 2.2.3 via apt-get
http://packages.ubuntu.com/hardy/postgresql-8.3-postgis
With that setup, my postgis_full_version() SQL command returned:
POSTGIS="1.3.3" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS

However, I required an upgrade due to bugs with that version of PostGIS and/or geos (namely ST_Buffer). So, I uninstalled the apt-get builds of proj, geos and postgis packages, and manually built proj, geos, and postgis from source using the current stable versions. Now my postgis_full_version() returns:
POSTGIS="1.3.6" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS

The database functions normally, and QGIS can connect, ST_Buffer works, etc. However, I cannot connect or use the database as I did before the upgrade with the PostGIS provider. When attempting to connect, Map3D 2008 crashes with an error "AutoCAD cannot continue" an no other message. Map3D 2010 doesn't crash, but throws an error/exception "There was a problem accessing the connection's schema information."

So, my question is if the version of PostGIS is important to the FDO provider, and if so, what versions are supported? This doesn't have a ticket, but I'll start one once I know a bit more info about the versions.

Thanks,

-Mike
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users