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

Hello! I've been able to successfully setup the map server locally, but now I'm trying to configure the system to hit a remote Postgres instance. However, I can't figure out where this is configured. I've tried adding parameters to the mapnik.xml file, but it still appears to hit the localhost:

renderd[20693]: An error occurred while loading the map layer 'ajt': Postgis Plugin: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

For reference, I was using this URL for the mapnik parameters: https://github.com/mapnik/mapnik/wiki/PostGIS

I've also tried guessing at what the host, user, and password variable names would be in renderd.conf, but haven't had luck with this either. Does someone have a link to an example or documentation on how to hit a remote Posgres instance? I've already loaded all of the data for North America into the external Postgres server, so I'd very much like to use that if possible.

asked 05 Mar '18, 17:20

gordysc's gravatar image

gordysc
26113
accept rate: 0%


It looks like I've had a bit of a break through (of course after posting this question).. For future reference, I added host, user, and password to osm2pgsql in project.mml and then regenerated the file using carto project.mml > mapnik.xml . This seemed to cause the server to connect to the database on startup. However, I'm getting connection timeouts when loading /hot/0/0/0.png. Will post back later if I figure out why.

permanent link

answered 05 Mar '18, 17:31

gordysc's gravatar image

gordysc
26113
accept rate: 0%

One more follow up, this solves the connection issue: https://help.openstreetmap.org/questions/32367/rendering-open-street-map-stoped

For some reason the server went extremely fast rendering the tiles after leaving it for an hour. Perhaps it was creating indexes, etc? Anyway, hope all of this helps someone down the road!

(05 Mar '18, 19:06) gordysc

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

Question tags:

×165
×4
×2

question asked: 05 Mar '18, 17:20

question was seen: 3,467 times

last updated: 05 Mar '18, 19:06

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