wiki:FdoPostGISNotes

Version 21 (modified by PowerKiKi, 15 years ago) ( diff )

--

FDO PostGIS Provider Notes

This provider is now integrated into the main FDO release process.

If you are using the PostGIS provider, please be aware of these limitations:

  • Spatial tables must have entries in the geometry_columns table
  • The PostGIS provider currently does not support anything but lowercase identifiers consistently (database, schema, table, column)
  • If you add a table in MapGuide which does not contain a primary key, no columns will show up in the properties list
  • You need to run VACUUM ANALYSE on your spatial tables regularly if you want them to work well

If you run into problems, ask on the fdo-users mailing list and, if you think you have a bug, follow the instructions on the Ticket Submission page:

Authors / Contributors

Mateusz Loskot was the original author of this provider, working under contract to Refractions Research and the City of Nanaimo.

Bruno Scott of GeoMap is the current maintainer.

Download

Since version 3.3, the provider is now included as part of the standard FDO distribution, which can be found here:

http://fdo.osgeo.org/content/downloads

Or you can visit our download site directly:

http://download.osgeo.org/fdo/

There may also be interim unofficial beta builds available at the maintainer's website:

http://www.geomapgis.com/web/geomap-group/fdo/index.html

Installation (Windows)

  • Copy the DLLs into your fdo/bin directory
  • Add the following to your providers.xml file, using the correct version number for your release:
  <FeatureProvider>
    <Name>OSGeo.PostGIS.3.4</Name>
    <DisplayName>OSGeo FDO Provider for PostGIS</DisplayName>
    <Description>FDO Provider for PostGIS</Description>
    <IsManaged>False</IsManaged>
    <Version>3.4.0.0</Version>
    <FeatureDataObjectsVersion>3.4.0.0</FeatureDataObjectsVersion>
    <LibraryPath>.\PostGISProvider.dll</LibraryPath>
  </FeatureProvider>

  • Ensure that your computer the Postgresql/bin directory at the beginning of the SYSTEM part of the PATH environment variable, especially for server installations like MapGuide. Alternately, determine which PostgreSQL DLLs this provider requires using depends.exe, and copy them into the fdo/bin directory.
  • Reboot your computer

Connection Parameters

When you attempt to establish a connection with the PostGIS provider, you will need to fill in a number of parameters. These are described below:

Username::

Your postgresql userid

Password::

Your postgresql password

Service::

This is a connection string in the format "database@host:port" where @host and :port are optional if your database is on localhost and on the default port (5432)

Datastore::

This is the PostgreSQL schema the data is stored under. By default, all tables are stored under the "public" schema. However, this practice is not recommended as it makes postgis dump/restore procedures messy and difficult.

Open Tickets

#1003
Materialized Views not filtered

Note: See TracWiki for help on using the wiki.