Opened 3 years ago

Closed 16 months ago

#702 closed defect (fixed)

Postgis is installed but still not found

Reported by: dmisev Owned by: bphamhuu
Priority: major Milestone: 9.0.x
Component: petascope Version: development
Keywords: Cc: pcampalani
Complexity: Medium

Description

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

Change History (7)

comment:1 Changed 3 years ago by dmisev

find works fine:

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

comment:2 Changed 3 years ago by dmisev

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

comment:3 Changed 3 years ago by pcampalani

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

comment:4 Changed 3 years ago by pcampalani

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

comment:5 Changed 16 months ago by bphamhuu

  • Owner changed from arezaeim to bphamhuu
  • Status changed from new to assigned

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

comment:6 Changed 16 months ago by dmisev

Sounds good :)

comment:7 Changed 16 months ago by bphamhuu

  • Resolution set to fixed
  • Status changed from assigned to closed

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

Note: See TracTickets for help on using tickets.