Re: [OSM-talk] osm2pgsql & planet: frustrations, cutoffs, and idempotence

2008-10-26 Thread Michal Migurski
On Oct 26, 2008, at 5:50 PM, Frederik Ramm wrote: > Brett Henderson has offered to look into creating the dailies from > history as well, but I don't know about the status of that. > > If you use osmosis, it is safe (and in fact recommended) that, after > loading the database with a planet fil

Re: [OSM-talk] osm2pgsql & planet: frustrations, cutoffs, and idempotence

2008-10-26 Thread Michal Migurski
>> The final event in each weekly planet dump does not fall on an >> even day boundary. In the case of the most recent Oct. 22nd >> planet.osm, it was necessary to experiment with hourly diffs from >> that day to find that the boundary was approx. 2:00pm. Hourlies up >> to and including

Re: [OSM-talk] osm2pgsql & planet: frustrations, cutoffs, and idempotence

2008-10-26 Thread Frederik Ramm
Hi, Michal Migurski wrote: > I've noticed some misalignments between the data in the dumps and the > osm2pgsql importer that leads to unavoidable holes in the data. As TomH has already said, this is not a bug, it stems from the fact that the full planet export reads the "current" tables and as

Re: [OSM-talk] osm2pgsql & planet: frustrations, cutoffs, and idempotence

2008-10-26 Thread Tom Hughes
Michal Migurski wrote: > The final event in each weekly planet dump does not fall on an even > day boundary. In the case of the most recent Oct. 22nd planet.osm, it > was necessary to experiment with hourly diffs from that day to find > that the boundary was approx. 2:00pm. Hourlies up to an

[OSM-talk] osm2pgsql & planet: frustrations, cutoffs, and idempotence

2008-10-26 Thread Michal Migurski
Hi, I've been trying to keep up to date with the dumps and diffs from http://planet.openstreetmap.org/ , and I'm running into a number of bugs related to cutoff dates. In keeping my Bay Area tiles (http://mike.teczno.com/notes/cascadenik-openstreetmap.html ) up to date, I've been grabbing com

Re: [OSM-talk] osm2pgsql password for non-interactive use

2008-09-17 Thread Martijn van Oosterhout
On Tue, Sep 16, 2008 at 9:57 PM, Michal Migurski <[EMAIL PROTECTED]> wrote: > Hi, > > It appears that osm2pgsql (SVN version 0.55-20080901) does not have a > way to specify the db password on the command line. Is this true? > > It'd be nice to be able to run it without needing to babysit the > pass

[OSM-talk] osm2pgsql password for non-interactive use

2008-09-16 Thread Michal Migurski
Hi, It appears that osm2pgsql (SVN version 0.55-20080901) does not have a way to specify the db password on the command line. Is this true? It'd be nice to be able to run it without needing to babysit the password prompt at the beginning. Can this be added a flag? -mike. ---

Re: [OSM-talk] osm2pgsql - invalid input syntax for integer : "Breërivier"

2008-04-18 Thread Ricardo Peironcely
Yes, downloading the last version fron SVN the error was resolved. Thanks. Rpr 2008/4/16, Martijn van Oosterhout <[EMAIL PROTECTED]>: > > On Wed, Apr 16, 2008 at 7:05 PM, Ricardo Peironcely > <[EMAIL PROTECTED]> wrote: > > > > I've a problem with osm2pgsql and the last version of planet file. >

Re: [OSM-talk] osm2pgsql - invalid input syntax for in teger: "Breërivier"

2008-04-16 Thread Martijn van Oosterhout
On Wed, Apr 16, 2008 at 7:05 PM, Ricardo Peironcely <[EMAIL PROTECTED]> wrote: > > I've a problem with osm2pgsql and the last version of planet file. > > When I try to execute the process, always receive the same error: invalid > input syntax for integer: "Breërivier" > > Any one knows something ab

[OSM-talk] osm2pgsql - invalid input syntax for integer : "Breërivier"

2008-04-16 Thread Ricardo Peironcely
I've a problem with osm2pgsql and the last version of planet file. When I try to execute the process, always receive the same error: invalid input syntax for integer: "Breërivier" Any one knows something about this? Thanks in advance. Rpr ./osm2pgsql -u -U postgres -d map planet-080409.osm.bz2

<    1   2