Opened 7 years ago

Closed 7 years ago

#16652 closed Cleanup/optimization (needsinfo)

location of postgis.sql & spatial_ref_sys.sql need to be corrected.

Reported by: Eric Jarvies Owned by: nobody
Component: Documentation Version: 1.3
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Aymeric Augustin)

Currently the PostGIS instructions indicate the user should do this:

$ psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql
$ psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql

it errors with this:

/usr/share/postgresql/8.4/contrib/postgis-1.5.2/postgis.sql: No such file or directory

The reason for the directory not being found, is because the postgis.sql & spatial_ref_sys.sql files are located in a 1.5 folder instead of a 1.5.2 folder:


Eric Jarvies

Change History (3)

comment:1 Changed 7 years ago by anonymous

This ticket pertains to the instructions located at:

comment:2 Changed 7 years ago by Aymeric Augustin

Description: modified (diff)

Fixed formatting (please use preview).

comment:3 Changed 7 years ago by Aymeric Augustin

Resolution: needsinfo
Status: newclosed

The docs contain this line:

POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib/postgis-1.5

which resolves to


However, your report shows that you have


(with an extra .2 at the end).

I don't understand how you end up with this value. The problem might be on your side.

If I missed something in the docs, could you provide more information, like the distribution you're using, the sequence of commands you typed, and the point where the procedure failed?

Note: See TracTickets for help on using tickets.
Back to Top