Using Django==5.1 minimum supported version for PostgreSQL is 13

turpialdev

I'm using Django==5.1 and psycopg==3.1.16 the minimum supported version for PostgreSQL is 13 but 11.22 was found

How can I upgrade PostgreSQL to version 13 or newer?

Here is the full traceback:

(env) [wellpro@vps129 wellpro]$ ./manage.py migrate
Traceback (most recent call last):
  File "/home/wellpro/apps/wellpro/wellpro/./manage.py", line 22, in <module>
    main()
  File "/home/wellpro/apps/wellpro/wellpro/./manage.py", line 18, in main
    execute_from_command_line(sys.argv)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/base.py", line 413, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/base.py", line 459, in execute
    output = self.handle(*args, **options)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/base.py", line 107, in wrapper
    res = handle_func(*args, **kwargs)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 118, in handle
    executor = MigrationExecutor(connection, self.migration_progress_callback)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in __init__
    self.build_graph()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 89, in applied_migrations
    if self.has_table():
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 63, in has_table
    with self.connection.cursor() as cursor:
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 320, in cursor
    return self._cursor()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 296, in _cursor
    self.ensure_connection()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 279, in ensure_connection
    self.connect()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 258, in connect
    self.init_connection_state()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 402, in init_connection_state
    super().init_connection_state()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 225, in init_connection_state
    self.check_database_version_supported()
  File "/home/wellpro/apps/wellpro/env/lib/python3.10/site-packages/django/db/backends/base/base.py", line 200, in check_database_version_supported
    raise NotSupportedError(
django.db.utils.NotSupportedError: PostgreSQL 13 or later is required (found 11.22).

My requirements.txt contents is:

Django==5.1.0
django-bootstrap5==23.4
django-extra-views==0.15.0
django-preventconcurrentlogins==0.8.2
djangorestframework==3.15.0
crispy-bootstrap5==2024.2
gunicorn==23.0.0
numpy==1.26.4
psycopg==3.1.16
python-decouple==3.8
# Development tools
pytest==8.0.0
pytest-django==4.7.0
flake8==7.0.0
black==24.1.1

sean

turpialdev We'll be upgrading PostgreSQL to v14 on your VPS some time next week. You should have received an email regarding this a couple of weeks ago.

If you want to try to build a newer version of PostgreSQL yourself there's a procedure at https://community.opalstack.com/d/1107-django-42-deprecates-postgresql-11-support/7 that might help. That procedure was written for v12 but you should be able to adapt it to a newer version.