|
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. |
|
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. 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
|