Opened 3 years ago

Closed 3 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 aaugustin)

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

Attachments (0)

Change History (3)

comment:1 Changed 3 years ago by anonymous

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset

This ticket pertains to the instructions located at:

comment:2 Changed 3 years ago by aaugustin

  • Description modified (diff)

Fixed formatting (please use preview).

comment:3 Changed 3 years ago by aaugustin

  • Resolution set to needsinfo
  • Status changed from new to closed

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?

Add Comment

Modify Ticket

Change Properties
<Author field>
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.