[Tile-serving] osm2pgsql with PostGis 2.x?

[Alex O'Ree]

Paul

Awesome. it's importing now. Thanks for the help!

On Sun, Sep 27, 2015 at 5:04 PM, Paul Norman <penorman at mac.com> wrote:
> On 9/27/2015 1:23 PM, Alex O'Ree wrote:
>>
>> Thanks for the reply. On ubuntu 14, i was able to install most the
>> packages, however osm2pgsql fails when importing about a missing
>> function, addgeometrycolumn (or something like that). This was with
>> postgres 9.3 and postgis 2.1. After some googling, it looked like with
>> was postgis not being applied correctly (but it was with create
>> extension postgis).
>
>
> AddGeometryColumn is in both PostGIS 2.x and 1.5, so it looks like you
> didn't install PostGIS on the database you were importing into. Try dropping
> the database, recreating it, installing PostGIS with CREATE EXTENSION, and
> running osm2pgsql. Be sure to document your commands and use the same
> database for osm2pgsql.
>
>> I also tried using ubuntu 12 with postgres 9.1, but couldn't get
>> postgis 1.5 binaries, seams it's missing from the repos along with
>> most of the dependencies to build it.
>
> Don't try to do this. Use 2.0 with 9.1 if you do need something that old for
> some reason.
>
>
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving