= 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 [SubmitTicket 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: {{{ OSGeo.PostGIS.3.4 OSGeo FDO Provider for PostGIS FDO Provider for PostGIS False 3.4.0.0 3.4.0.0 .\PostGISProvider.dll }}} * 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 == [[TicketQuery(status=new|assigned|reopened&component^=PostGIS&order=priority)]]