I don't think you can just use a history file with osm2pgsql. The history file contains deleted objects and objects in several versions. You have to use the history renderer: https://github.com/MaZderMind/osm-history-renderer
Jochen On Sat, Nov 09, 2013 at 03:33:58PM +0100, Maurizio Napolitano wrote: > Date: Sat, 9 Nov 2013 15:33:58 +0100 > From: Maurizio Napolitano <napoo...@gmail.com> > To: Jochen Topf <joc...@remote.org> > Cc: OSM Talk <talk@openstreetmap.org> > Subject: Re: [OSM-talk] Planet History file available > > Thanks! > here the file > https://dl.dropboxusercontent.com/u/1969597/matera.osh.gz > and here the sequence of command used > > wget https://dl.dropboxusercontent.com/u/1969597/matera.osh.gz > cat > history.style << EOF > node,way osm_user text > node,way osm_uid int8 > node,way osm_version int8 > node,way osm_timestamp text > EOF > createdb osmhistorydb > echo "CREATE EXTENSION postgis;CREATE EXTENSION hstore;CREATE > EXTENSION btree_gist" | psql osmhistorydb > osm2pgsql -d osmhistorydb -m -x -k -S history.style matera.osh.gz > > and here the error from osm2pgsql > > Sharing dense sparse > Node-cache: cache=800MB, maxblocks=102400*8192, allocation method=3 > Mid: Ram, scale=100 > > Reading in file: matera.osh.gz > osm2pgsql: parse-xml2.c:103: StartElement: Assertion `xlon' failed. > Aborted (core dumped) > > > >> > >> > >> the file "history.style" contains this configuration > >> > > > and the file is here > > > On Thu, Nov 7, 2013 at 9:02 AM, Jochen Topf <joc...@remote.org> wrote: > > I don't know either. We need more information to help you debug this. For > > starters the actual command lines you used and the files you created. > > > > Jochen > > > > On Wed, Nov 06, 2013 at 12:28:28PM +0100, Maurizio Napolitano wrote: > >> Date: Wed, 6 Nov 2013 12:28:28 +0100 > >> From: Maurizio Napolitano <napoo...@gmail.com> > >> To: Jochen Topf <joc...@remote.org> > >> Cc: OSM Talk <talk@openstreetmap.org> > >> Subject: Re: [OSM-talk] Planet History file available > >> > >> Hi Jochen > >> I used your file without problem with osm-history-splitter and also > >> osm-history-import > >> > >> With this tools i created an extraction of a region. > >> Now i used it also with osm2pgsql with this syntax > >> > >> osm2pgsql -d osmh -u -m -x -k -S history.style file.osh > >> > >> the file "history.style" contains this configuration > >> > >> node,way osm_user text > >> node,way osm_uid int8 > >> node,way osm_version int8 > >> node,way osm_timestamp text > >> > >> The import fails with this message > >> > >> Reading in file: /home/napo/Desktop/file.osh > >> osm2pgsql: parse-xml2.c:101: StartElement: Assertion `xlon' failed. > >> Aborted (core dumped) > >> > >> I don't know if this is my fault or from the file > >> > >> Thanks > >> > >> > >> > >> On Mon, Nov 4, 2013 at 9:25 AM, Jochen Topf <joc...@remote.org> wrote: > >> > Due to popular demand I have made a planet file with full history > >> > available at > >> > http://data.openstreetmapdata.com/planet-history-2013-11-02.osh.pbf > >> > The file has about 37 GB, it's MD5 is 22169f0f997391b090df546769eb2357. > >> > > >> > This was generated from the last official history and all the daily diffs > >> > until two days ago. THIS IS NOT AN OFFICIAL HISTORY FILE. > >> > > >> > I haven't tested it or verified that my code that generates this is > >> > doing the > >> > right thing, so no guarantees. (On the other hand there is not much to > >> > it, > >> > really, just collect all the objects in the planet and change files and > >> > put > >> > them in the right order.) Apply reasonable caution when using it. > >> > > >> > If there is demand I can make a osm.bz2 version available, too. > >> > > >> > Jochen > >> > -- > >> > Jochen Topf joc...@remote.org http://www.jochentopf.com/ > >> > +49-721-388298 > >> > > >> > _______________________________________________ > >> > talk mailing list > >> > talk@openstreetmap.org > >> > https://lists.openstreetmap.org/listinfo/talk > >> > >> > >> > >> -- > >> Maurizio "Napo" Napolitano > >> http://de.straba.us > > > > -- > > Jochen Topf joc...@remote.org http://www.jochentopf.com/ +49-721-388298 > > > > -- > Maurizio "Napo" Napolitano > http://de.straba.us -- Jochen Topf joc...@remote.org http://www.jochentopf.com/ +49-721-388298 _______________________________________________ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk