<br><div class="gmail_quote">On Thu, Aug 13, 2009 at 2:35 PM, Peter Körner <span dir="ltr"><<a href="mailto:osm-lists@mazdermind.de">osm-lists@mazdermind.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im"><br>
</div>It is possible to connect to the local postgres-db, although it is very<br>
outdated (it's from 2009-07-15) and not updated at the moment. It is<br>
also possible to connect to the sql-servers.<br>
<br>
Tools may be written in php, perl or python, although i can't guarantee<br>
that everything will work in every language right now, but i don't see<br>
any problems that can't be resolve by a ticket in jira.<br>
<br>
I think i could write a beginners-guide on how to use cassini (I'd<br>
propose <a href="https://wiki.toolserver.org/view/Cassini/Usage_notes" target="_blank">https://wiki.toolserver.org/view/Cassini/Usage_notes</a>) but at the<br>
moment it's not too useful as the main database is not updated.<br>
<br>
I worked around this by once doing an import of all country-nodes from<br>
the (outdated) postgresql-database into my mysql-db and have them<br>
checked regularly against the api. This works for countries (no support<br>
for new nodes, only ~230 nodes to fetch) but if you'd like to do<br>
something similar on a city-level, this wouldn't work anymore.<br>
<br>
So what is needed to get the database updated? I don't think we'll need<br>
a root-user to do this, just someone with write-perms on /sql and maybe<br>
a file under /etc/cron.d/. I never set up a postgres-db with<br>
hourly/minutely diff-support but I think I could give it a try, if this<br>
would be ok. On the other hand, if someone already has experience whith<br>
such a setup, he's welcome to do this.<br>
<br>
Any suggestions?<br>
<font color="#888888">Peter<br>
</font><div><div></div><div class="h5"><br>
</div></div></blockquote><div><br>The osm planet needs to be re-imported into the mapnik PostgresSQL database, with the intarray (_int.sql) module enabled on the gis database before doing the import. <br><br>This requires either root access or sudo privileges to run commands as user postgres. I have submitted a jira ticket, requesting sudo privileges so that I can work on this. <br>
<br>Once planet osm is re-imported, the database will be setup to handle regular imports of OSM .osc diff files using osm2pgsql.<br><br>-Aude<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div class="h5">_______________________________________________<br>
Maps-l mailing list<br>
<a href="mailto:Maps-l@lists.wikimedia.org">Maps-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/maps-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/maps-l</a><br>
</div></div></blockquote></div><br>