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

[Paul Norman]

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.