Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

install-postgis-osm-db.sh not work on PostgreSQL9.1 #4041

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 2 comments
Closed

install-postgis-osm-db.sh not work on PostgreSQL9.1 #4041

openstreetmap-trac opened this issue Jul 23, 2021 · 2 comments
Assignees
@openstreetmap-trac
Labels
Component: osm2pgsql Priority: minor Resolution: wontfix Type: defect

Comments

@openstreetmap-trac
Copy link

Reporter: max[at]stranger-team.ru
[Submitted to the original trac issue database at 6.13am, Saturday, 8th October 2011]

  1. "/usr/share/postgresql/[PG_VERSION]/contrib/" is deprecated, it's a Debian only specific path. Need "/usr/share/postgresql/contrib/"

  2. createlang plpgsql always return error on pgsql 9.1, because plpgsql is already installed in database by default. Need "|| true" to end of command
@openstreetmap-trac openstreetmap-trac self-assigned this Jul 23, 2021
@openstreetmap-trac
Copy link
Author

Author: max[at]stranger-team.ru
[Added to the original trac issue at 4.07pm, Sunday, 9th October 2011]

  1. Script use unset variable DBNAME, and psql use DB postgres.

@openstreetmap-trac
Copy link
Author

Author: amm
[Added to the original trac issue at 2.33pm, Saturday, 22nd October 2011]

There is a slightly updated version of the script in svn. It handles PostgreSQL 9.1 and the fixes the plpgsql issue.

However, 9.1 and 8.4 need to be handled differently. Without the PG_VERSION in the path, how is one supposed to determine which version of postgres is running from bash?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@openstreetmap-trac openstreetmap-trac

Labels
Component: osm2pgsql Priority: minor Resolution: wontfix Type: defect
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@openstreetmap-trac