search

ckan / ckanext-spatial

Geospatial extension for CKAN
http://docs.ckan.org/projects/ckanext-spatial
125 stars 192 forks source link

Installation and Setup documentation is outdated #246

Open Chealer opened 4 years ago

Chealer commented 4 years ago

The Install PostGIS and system packages section of the documentation is outdated, covering only Ubuntu 12.04 and 14.04.

Starting from PostgreSQL 9.2, there is a simpler way of enabling PostGIS than directly running the SQL files.

Note that the "Install the extension" step's name is ambiguous, since PostGIS is also an extension. It would be clearer to name it "Install the extension of CKAN".

Chealer commented 4 years ago

It would be very important to instruct to use CREATE EXTENSION rather than the old way, because without it, pg_dump backs up all non-system objects, including PostGIS, as explained in section 33.2 of PostGIS's documentation:

PostgreSQL 9.1+ includes an “EXTENSION” feature that allows add-on packages like PostGIS to be installed as registered system components and therefore excluded from pg_dump output. PostGIS 2.0 and higher support installation using this extension system.

This creates major trouble when trying to restore (unless perhaps the PostGIS version doesn't change).

howff commented 3 years ago

Thanks for your tips. Could you give more explicit instructions? Thanks!

Chealer commented 3 years ago

I am sorry @howff but I haven't touched CKAN since August and I'm too old to ask my memory to detail.