Issues Upgrading to django 1.8 and migrating from south

[Marcela Campo]

Hi all,

  I am upgrading an app from django 1.5 + south to 1.8. I am having some issues when faking migrations with the recommended procedure here 

https://docs.djangoproject.com/en/1.8/topics/migrations/#upgrading-from-south

I am using postgres with postgis extension and engine 

 'ENGINE': 'django.contrib.gis.db.backends.postgis',

I followed the procedure indicated in the docs, solved circular dependencies issues etc. I tried locally and worked fine, but now in another environment I get the following error

 File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line

    utility.execute()

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 330, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/core/management/base.py", line 390, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/raven/contrib/django/management/__init__.py", line 41, in new_execute

    return original_func(self, *args, **kwargs)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/core/management/base.py", line 441, in execute

    output = self.handle(*args, **options)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 91, in handle

    connection.prepare_database()

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/contrib/gis/db/backends/postgis/base.py", line 39, in prepare_database

    cursor.execute("CREATE EXTENSION IF NOT EXISTS postgis")

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute

    return super(CursorDebugWrapper, self).execute(sql, params)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/db/utils.py", line 97, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/home/deploy/marcela-dev/src/hhenv_1_8/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 62, in execute

    return self.cursor.execute(sql)

django.db.utils.InternalError: PostGIS is already installed in schema 'public', uninstall it first

my env is

ubuntu 15.04

python 2.7.9

postgres 9.4.1

Django==1.8.2

psycopg2==2.6

Any ideas why this could be happening? Any help appreciated!

Thanks!

Marcela

[Tim Graham]

I guess you might have an old database created using the PostGIS template. See http://gis.stackexchange.com/questions/112592/installed-postgis-extension-not-listed-for-database

[Marcela Campo]

Hi Tim, many thanks for your help. That, indeed was the issue. Doing a hard upgrade solved it.

Cheers!
Marcela