[Talk-us] Weird Osmosis/ROMA/pgsql issue

Karl Newman siliconfiend at gmail.com
Thu Nov 6 19:09:53 GMT 2008


On Thu, Nov 6, 2008 at 10:42 AM, Milenko <milenko at king-nerd.com> wrote:

>  I thought able that, but this is a freshly loaded machine and I've only
> ever downloaded this one copy of osmosis.  Just for fun, I just did a file
> search for osmosis-0.29 and found only the one directory that I've been
> working in.
>
>
>
> -Jeremy
>
>
>
>
>
> *From:* talk-us-bounces at openstreetmap.org [mailto:
> talk-us-bounces at openstreetmap.org] *On Behalf Of *Karl Newman
> *Sent:* Thursday, November 06, 2008 1:16 PM
> *To:* Milenko
> *Cc:* talk-us at openstreetmap.org
> *Subject:* Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue
>
>
>
> On Thu, Nov 6, 2008 at 10:15 AM, Milenko <milenko at king-nerd.com> wrote:
>
>  Hey all,
>
>
>
>         I've been trying to get a local ROMA server working and I've run into an issue with getting osmosis working.  I've patched osmosis as per the instructions on the wiki (http://wiki.openstreetmap.org/index.php/Read_Only_Map_API), but when I import data into the pgsql database, I'm still seeing statements in the db log files that reference commands taken out by the patch.  One specific command is "UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM nodes JOIN way_nodes ON way_nodes.node_id = nodes.id WHERE way_nodes.way_id = ways.id)", seen in PostgreSqlWriter.java.  I've verified that it's removed from that file but it still runs when I try to import data.  This command takes days when trying to import the full planet.
>
>
>
>         Anyone have any idea how this is happening?  I've searched every file in the osmosis directory and can't find that command, and yet it still somehow gets run during the import.
>
>
>
>
>
> Any help would be greatly appreciated.
>
>
>
> -Jeremy
>
>   Are you sure you're actually executing your patched version and not an
> unpatched version that's somewhere on your path?
>
I don't know anything about the patch, but did you look in the script
directory, at the pgsql_simple_load_0.5.sql file? That command is in there
(spread over multiple lines, which is why a grep may not have found it).

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us/attachments/20081106/9d31dfdb/attachment.html>


More information about the Talk-us mailing list