django tests using postgis

[funkmyster]

When running our newly developed test suite for geolocation, I kept receiving:

createlang -d test_<projectDB> -U <username> plpgsql
Traceback (most recent call last):
  File "./manage.py", line 11, in <module>
    execute_manager(settings)
  File "/usr/local/lib/python2.6/site-packages/django/core/management/__init__.py", line 359, in execute_manager
    utility.execute()
  File "/usr/local/lib/python2.6/site-packages/django/core/management/__init__.py", line 304, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python2.6/site-packages/django/core/management/base.py", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/local/lib/python2.6/site-packages/django/core/management/base.py", line 222, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.6/site-packages/django/core/management/commands/test.py", line 23, in handle
    failures = test_runner(test_labels, verbosity=verbosity, interactive=interactive)
  File "/usr/local/lib/python2.6/site-packages/django/contrib/gis/tests/__init__.py", line 135, in run_tests
    create_test_spatial_db(verbosity=verbosity, autoclobber=not interactive)
  File "/usr/local/lib/python2.6/site-packages/django/contrib/gis/db/backend/postgis/creation.py", line 119, in create_test_spatial_db
    create_lang(db_name, verbosity=verbosity)
  File "/usr/local/lib/python2.6/site-packages/django/contrib/gis/db/backend/postgis/creation.py", line 25, in create_lang
    raise Exception("Error executing 'plpgsql' command: %s\n" % output)
Exception: Error executing 'plpgsql' command: 

apparently if 'plpgsql' is pre-installed on the newly generated instance:

createlang -d test_<projectDB> -U <username> plpgsql

...raises an exception with the value 2, thus breaking the test suite. Note my stack was built from source.

[funkmyster]

patch

[Gary Wilson]

Fixed ticket formatting.

[jbronn]

We added the POSTGIS_TEMPLATE (​docs) setting for this exact reason -- set it with the name of your ​spatial database template that already has the procedural language created along with the PostGIS extension.

[Vinay Sajip]

I get the same error when trying to create the postgis_template database using the 'create_template_postgis_debian.sh' script, because plpgsql is apparently already present. Although in this case an error code of 2 is returned from createlang, it's not really an error, so the script should continue to add functions etc. to the template, but it bails before then.

This occurred on Ubuntu Oneiric 64-bit, PostgreSQL 9.1. So I cannot create a valid postgis_template database.

[Aymeric Augustin]

This ticket describes a problem that happens when you run the test suite. If I understand correctly, your problem happens earlier, when your create the postgis_template database, so it's a different one.

Could you create a new ticket, if possible with more detail? Attaching the log of your terminal session would be very useful, we could try to understand the cause without setting up an Ubuntu.

Thanks!

[Claude Paroz]

See comment:5 if you still have an issue, but please don't reopen this ticket.