[OSM-dev] Osmosis and Postgresql

[Brett Henderson]

Graham Jones wrote:
> Hi Folks,
> I have spent a couple of evenings trying to persuade osmosis to import 
> a planet dump into postgresql.
>
> It was quite a lot harder than I expected because of the need to set 
> up the database schema, postgis etc. first (I am not used to 
> postgresql, which was a lot of the problem).
>
> I have had a go at drafting a procedure for setting this up for the 
> first time at:
> http://wiki.openstreetmap.org/wiki/Talk:Osmosis#Procedure_to_import_data_into_PostGreSQL
>
> Would someone that know more about this than me mind having a look and 
> pointing out my mistakes please?  Once it is right I'll add it as a 
> separate wiki page rather than hiding it in the 'talk' bit.
Hi Graham,

Thanks for taking the effort to document this.  The Osmosis 
documentation is lacking in a number of areas, this is one of them :-)  
I see you've already added a link from the Osmosis detailed usage page 
which is great.

If you get a chance, check out the --write-pgsql-dump task which is a 
much faster (but less convenient) way of importing very large data 
sets.  If you or somebody else has some time to document that procedure 
it would be very helpful.

Cheers,
Brett