From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl Newman Sent: Thursday, November 06, 2008 2:10 PM To: Milenko Cc: [email protected] Subject: Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue On Thu, Nov 6, 2008 at 10:42 AM, Milenko <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl Newman Sent: Thursday, November 06, 2008 1:16 PM To: Milenko Cc: [email protected] Subject: Re: [Talk-us] Weird Osmosis/ROMA/pgsql issue On Thu, Nov 6, 2008 at 10:15 AM, Milenko <[EMAIL PROTECTED]> 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 Yes, I found it there also. I believe that file is used for loading txt files from a db dump and shouldn't be called during normal osmosis usage. To be safe, I removed the statements from that file also and they still are run when I import data. -Jeremy
_______________________________________________ Talk-us mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-us
