Menu ▾ ▴

createlang: language "plpgsql&quo...

Help
Thagor
2011-06-30
2013-05-30

  • Thagor

    Thagor - 2011-06-30

    Hi I'm using Postgresql 9.0.3 Server with already installed PostGIS
    when i try to run 

    ./osm2postgresql_03.sh --osm ./monaco.osm

    the script stops at 

    createlang: language "plpgsql" is already installed in database "OSM2011-06-30_15:03:58"
Error 2. The command which triggered the error was:
createlang $pgconnect_user plpgsql $dbname
on line 366 of the osm2postgresql script.

    is the script simply not yet compatible with Postgresql 9 ?

    thx for the help

     

  • Mayeul

    Mayeul - 2011-07-04

    Hi Thagorx,
    Thanks a lot for the feedback and sorry for the late reply.
    You are right. Basically default install for Postgresql 9.0 has a template with plpgsql already installed in every database. QUick fix is to comment out the line with "createlang" in your case.
    I will post an updated version of the script very soon.
    Mayeul

     

  • Mayeul

    Mayeul - 2011-07-04

    Hi,
    The new version osm2postgresql_04.sh now solves the issue. Tested on postgresql 8.4 and 9.0. Please tell us if it works for you, thanks!
    Mayeul

     

Log in to post a comment.