Emilie, Thank you for looking at that for me - I will have a look at the other options now I have got it working. I know what you mean about seeing what it is doing, so dumping the SQL to a file then importing it will make it easier to understand.
I can't remember why I included postgres-contrib - I thought I needed it to get osmosis to compile properly, but I could be wrong! Graham 2009/6/19 Emilie Laffray <[email protected]> > 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. > Hello, > > I have just had a look at what you have written. It looks good to me. I > usually do not use the task to write directly into postgres and instead > I generate the pgsql dump and import them later on. Based on experience, > it is just faster. If you do that, you have to add an extra step which > is found in the load script provided also with Osmosis. > Also, because I don't like not to know what is happening, I add some > logging to see what the program is doing. > In addition, the import information that you have given do not take into > account the optional columns for bboxbuilder and linestringbuilder, > which can be useful for some people. We may want to add a comment about > those options. > Other than that, your instructions are a pretty good to get started. > One quick note, you are installing postgres contrib but you are not > making use of any of the scripts that are present inside contrib. One of > the useful script is the admin script especially if you are using pgadmin. > > Emilie Laffray > > -- Dr. Graham Jones Hartlepool, UK email: [email protected]
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
