<div class="gmail_extra">No actually the answer was i need to install the psycopg2 in the virtual-env. It is finally working thanks.</div><div class="gmail_extra"><br></div><div class="gmail_extra">The solution is here <a href="http://stackoverflow.com/questions/10304367/unable-to-syncdb-in-geodjango-app#comment13263738_10304367">http://stackoverflow.com/questions/10304367/unable-to-syncdb-in-geodjango-app#comment13263738_10304367</a><br>
<br><div class="gmail_quote">On Wed, Apr 25, 2012 at 6:16 AM, Travis Kirstine <span dir="ltr"><<a href="mailto:traviskirstine@gmail.com" target="_blank">traviskirstine@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I think you need to change the ENGINE to use the postgresql_psycopg2 adapter<br>
<br>
'ENGINE': 'django.contrib.gis.db.backends.postgresql_psycopg2', # Add<br>
'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.<br>
<br>
Regards<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<br>
On 24 April 2012 13:21, Smaran Harihar <<a href="mailto:smaran.harihar@gmail.com">smaran.harihar@gmail.com</a>> wrote:<br>
> how do I verify if my database is proper?<br>
><br>
><br>
> On Tue, Apr 24, 2012 at 10:14 AM, Smaran Harihar <<a href="mailto:smaran.harihar@gmail.com">smaran.harihar@gmail.com</a>><br>
> wrote:<br>
>><br>
>> thanks for replying. I have attached the settings.py file<br>
>><br>
>><br>
>> On Tue, Apr 24, 2012 at 10:10 AM, Nabil Servais <<a href="mailto:nabil.servais@gmail.com">nabil.servais@gmail.com</a>><br>
>> wrote:<br>
>>><br>
>>> Could you post your settings.py please? I think it's a problem with the<br>
>>> database section.<br>
>>><br>
>>> Le 24 avr. 2012 19:03, "Smaran Harihar" <<a href="mailto:smaran.harihar@gmail.com">smaran.harihar@gmail.com</a>> a<br>
>>> écrit :<br>
>>>><br>
>>>> Hi,<br>
>>>><br>
>>>> I am really fed up in setting up and running GeoDjango.<br>
>>>><br>
>>>> The first step was to setup the Spatial Database in PostGIS which I was<br>
>>>> really banging my head when it came to OS X. So i shifted to Ubuntu 11.10<br>
>>>> and it seemed it was quite easy. Now having completed the post installation<br>
>>>> process, I created the required changes that need to be done in the<br>
>>>> settings.py and now i am trying to,<br>
>>>><br>
>>>> python manage.py sqlall world<br>
>>>><br>
>>>> but it is returning a bunch of errors.<br>
>>>><br>
>>>> (django-env)smaranh@ubuntu:~/geodjango$ python manage.py sqlall world<br>
>>>> Traceback (most recent call last):<br>
>>>> File "manage.py", line 10, in <module><br>
>>>> execute_from_command_line(sys.argv)<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/__init__.py",<br>
>>>> line 443, in execute_from_command_line<br>
>>>> utility.execute()<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/__init__.py",<br>
>>>> line 382, in execute<br>
>>>> self.fetch_command(subcommand).run_from_argv(self.argv)<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/__init__.py",<br>
>>>> line 261, in fetch_command<br>
>>>> klass = load_command_class(app_name, subcommand)<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/__init__.py",<br>
>>>> line 69, in load_command_class<br>
>>>> module = import_module('%s.management.commands.%s' % (app_name,<br>
>>>> name))<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/utils/importlib.py",<br>
>>>> line 35, in import_module<br>
>>>> __import__(name)<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/commands/sqlall.py",<br>
>>>> line 4, in <module><br>
>>>> from django.core.management.sql import sql_all<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/core/management/sql.py",<br>
>>>> line 6, in <module><br>
>>>> from django.db import models<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/db/__init__.py",<br>
>>>> line 40, in <module><br>
>>>> backend = load_backend(connection.settings_dict['ENGINE'])<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/db/__init__.py",<br>
>>>> line 34, in __getattr__<br>
>>>> return getattr(connections[DEFAULT_DB_ALIAS], item)<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/db/utils.py",<br>
>>>> line 92, in __getitem__<br>
>>>> backend = load_backend(db['ENGINE'])<br>
>>>> File<br>
>>>> "/home/smaranh/django-env/local/lib/python2.7/site-packages/django/db/utils.py",<br>
>>>> line 44, in load_backend<br>
>>>> raise ImproperlyConfigured(error_msg)<br>
>>>> django.core.exceptions.ImproperlyConfigured:<br>
>>>> 'django.contrib.gis.db.backends.postgis' isn't an available database<br>
>>>> backend.<br>
>>>> Try using django.db.backends.XXX, where XXX is one of:<br>
>>>> 'dummy', 'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3'<br>
>>>> Error was: No module named psycopg2.extensions<br>
>>>><br>
>>>><br>
>>>> Really need your help guys.<br>
>>>><br>
>>>> --<br>
>>>> Thanks & Regards<br>
>>>> Smaran Harihar<br>
>>>><br>
>>>><br>
>>>> _______________________________________________<br>
>>>> postgis-users mailing list<br>
>>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
>>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
>>>><br>
>>><br>
>>> _______________________________________________<br>
>>> postgis-users mailing list<br>
>>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
>>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
>>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Thanks & Regards<br>
>> Smaran Harihar<br>
>><br>
><br>
><br>
><br>
> --<br>
> Thanks & Regards<br>
> Smaran Harihar<br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & Regards<div>Smaran Harihar</div><br>
</div>