Installation and Setup documentation is outdated

[Chealer]

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]

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]

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

[Chealer]

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