about faq

questions tags users badges unanswered

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

mapnik and postgresql in differents servers

1

I have installed:

on a server: mapnik, openstreetmap-carto and mod_tile in apache2

in another: postgresql, postgis

where I have to put the connection parameters to the database: user, password, host, port, ...

I tried:

 set | grep MAPNIK
MAPNIK_DBHOST=192.168.1.1
MAPNIK_DBNAME=gis
MAPNIK_DBPASS=xxxxxxxx
MAPNIK_DBPORT=5432
MAPNIK_DBUSER=userdb

with the same result

Do I have to install Mapnik-style (default) Or there somewhere to register values?

postgis mapnik mod_tile

asked 18 Aug '16, 16:08

arcadio ortega
41●4●5●6
accept rate: 0%

edited 18 Aug '16, 16:52

One Answer:

active answers oldest answers newest answers popular answers

1

I've never run Postgres on a different server, but I think you'd have to change the osm2pgsql connection settings inside the openstreetmap-carto project.

Add a host/user/etc value to this part:

  osm2pgsql: &osm2pgsql
    type: "postgis"
    dbname: "gis"
    key_field: ""
    geometry_field: "way"
    extent: "-20037508,-20037508,20037508,20037508"

See also: Mapnik's PostgreSQL settings.

The openstreetmap-carto style makes use of some shapefiles, you will need to have them locally on the mapnik server, not the postgresql server.

permanent link

answered 19 Aug '16, 07:51

rorym
5.4k●14●49●100
accept rate: 11%

I execute "carto project.mml > osm.xml" if I change something in project.yaml then nothing changes in osm.xml and everything stays the same.

(19 Aug '16, 08:12) arcadio ortega

Where I add this: PostGIS_user-content-usage-from-c it can be the solution

(19 Aug '16, 10:10) arcadio ortega

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

mapnik ×341
postgis ×134
mod_tile ×80

question asked: 18 Aug '16, 16:08

question was seen: 4,917 times

last updated: 19 Aug '16, 10:11

Related questions

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum