Yep, I just did this the other day on the demo server ... Get your database setup and working, use the django management command to dump and load the data into the other database and off you go.
http://docs.djangoproject.com/en/dev/ref/django-admin/ dumpdata and loaddata are the 2 commands. The exact sequence is like this. I used 2 local settings files and specified which one to use on the command line 1) Stand up new DB (install postgres, postgis etc) 2) Create the DB user and DB 3) Activate virtualenv 4) django-admin.py syncdb --settings=new_local_settings.py 5) django-admin.py dumpdata --settings=local_settings.py > geonode_data.json 6) django-admin.py loaddata geonode_data.json --settings=new_local_settings.py 7) mv local_settings.py local_settings_bkup.py 8) mv new_local_settings.py local_settings.py 9) restart apache to pick up the changes I did run into some issues with the fixtures not being generated in the right sequence, so received errors about trying to add layers with an non-existent owner. Basically had to do the dump/load data with the users first and then with the rest of the DB. Lemme know if that works for you. Jeff On Thu, Mar 17, 2011 at 9:57 AM, Jude Mwenda <[email protected]> wrote: > Any clue on migrating including data from sqlite to postgis? > > 2011/3/17 Jeff Johnson <[email protected]> >> >> It seems like it may be easier to use PostGIS for this? I've never had >> much luck with spatialite and GeoDjango, but its been a while since I >> have tried, and I think its become easier, but your issue indicates >> maybe not? >> >> Jeff >> >> On Thu, Mar 17, 2011 at 4:54 AM, Jude Mwenda <[email protected]> wrote: >> > Hi, >> > I would like to use some of geodjango's functions on my intance. On >> > adding >> > at the installed apps 'django.contrib.gis' i get the error >> > Only versions of pysqlite 2.5+ are compatible with SpatiaLite and >> > GeoDjango. >> > Any pointers on how to upgrade pysqlite to 2.5+? or is there an >> > alternative >> > to doing geometry functions saved on the sqlite database? such as >> > extent() >> > Regards > >
