Postgis is installed but still not found

[Dimitar Misev]

The update8.sh script fails to find postgis.sql, even though postgis has been installed, because sudo updatedb has not been run.

update8.sh: WARNING: PostGIS (postgis.sql) not found. Multipoint support will not be installed.

It will be best to revert to using find in this case, for these reasons:

• it's not a good idea to run sudo updatedb automatically in the script
• once this fails, it's complicated to re-run update_petascopedb.sh for multipoint to be enabled

[Dimitar Misev]

find works fine:

$ find / -name postgis.sql -print -quit 2> /dev/null
/usr/share/postgresql/9.1/contrib/postgis-2.1/postgis.sql

[Dimitar Misev]

After some searching find seems to be the most portable (but also slowest) solution.

[Piero Campalani]

Just a note: PostGIS 2.0 (our requirement) still works with PostgreSQL 8.4 installations.
​http://postgis.net/docs/manual-2.0/postgis_installation.html#idp5740368

[Piero Campalani]

We first should add an option to update_petascopedb.sh to specify the explicit intention to have PostGIS support: this way the execution exits if PostGIS is not detected (now just a WARNING is displayed).

This same option could then be used to enable the PostGIS support on an already synced database:

IF POSTGIS_OPTION IS SET
THEN 
    update_database()
    create PostGIS extension on petascopedb
    add PostGIS-dependent tables
END IF

[Bang Pham Huu]

I will take this ticket as tomorrow is Alizera's defend his PhD thesis so good luck to him.

[Dimitar Misev]

Sounds good

[Bang Pham Huu]

As patch has been submitted so Dr. Alizera can enjoy his joyful moment without any worry.