﻿id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
34086	Confirm support for PostGIS 3.3	Paolo Melchiorre	Paolo Melchiorre	" I checked that the tests pass on PostGIS 3.3.

== Files

`postgis.py`
{{{
#!python
DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'HOST': 'postgres',
        'NAME': 'geodjango',
        'PASSWORD': 'postgres',
        'PORT': 5432,
        'USER': 'postgres',
    },
    'other': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'HOST': 'postgres',
        'NAME': 'other',
        'PASSWORD': 'postgres',
        'PORT': 5433,
        'USER': 'postgres',
    },
}

SECRET_KEY = 'django_tests_secret_key'

USE_TZ = False
}}}

`docker-compose.yaml`
{{{
#!yaml
services:

  geodjango:
    environment:
      - POSTGRES_DB=geodjango
      - POSTGRES_PASSWORD=postgres
    image: postgis/postgis:14-3.3
    ports:
      - ""5432:5432""
    volumes:
      - geodjango_data:/var/lib/postgresql/data

  other:
    environment:
      - POSTGRES_DB=other
      - POSTGRES_PASSWORD=postgres
    image: postgis/postgis:14-3.3
    ports:
      - ""5433:5432""
    volumes:
      - other_data:/var/lib/postgresql/data

volumes:
  geodjango_data: {}
  other_data: {}
}}}

== Test

{{{
#!python
(django) paulox@net:~/Projects/django/tests$ time ./runtests.py --settings=postgis gis_tests --timing -v0
System check identified 52 issues (1 silenced).
----------------------------------------------------------------------
Ran 553 tests in 23.196s

OK (skipped=20)
Total database setup took 14.557s
  Creating 'default' took 2.982s
  Cloning 'default' took 0.639s
  Cloning 'default' took 0.481s
  Cloning 'default' took 0.564s
  Cloning 'default' took 0.542s
  Cloning 'default' took 0.551s
  Cloning 'default' took 0.475s
  Cloning 'default' took 0.452s
  Cloning 'default' took 0.470s
  Creating 'other' took 3.105s
  Cloning 'other' took 0.598s
  Cloning 'other' took 0.550s
  Cloning 'other' took 0.539s
  Cloning 'other' took 0.550s
  Cloning 'other' took 0.522s
  Cloning 'other' took 0.601s
  Cloning 'other' took 0.480s
  Cloning 'other' took 0.454s
Total database teardown took 2.556s
Total run took 40.594s
}}}

"	New feature	assigned	GIS	dev	Normal		postgis		Unreviewed	0	0	0	0	0	0
