#34086: Confirm support for PostGIS 3.3
-------------------------------------+-------------------------------------
Reporter: Paolo Melchiorre | Owner: Paolo
| Melchiorre
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: postgis | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by Paolo Melchiorre:
Old description:
> 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 description:
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
{{{
#!bash
(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
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/34086#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070183c85638d9-8c4dcdd4-d576-4764-80f8-e728ca040b2c-000000%40eu-central-1.amazonses.com.
