bad query: b'\n        CREATE EXTENSION postgis;\n        CREATE EXTENSION postgis_topology;\n    '
ERROR: permission denied to create extension "postgis"
HINT:  Must be superuser to create this extension.

Failed to initialize database `00304-master-all`.
Traceback (most recent call last):
  File "/data/build/Gitlab Phileas Community 18.0/base_geoengine/geo_db.py", line 36, in init_postgis
    cr.execute(
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/sql_db.py", line 364, in execute
    res = self._obj.execute(query, params)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.InsufficientPrivilege: permission denied to create extension "postgis"
HINT:  Must be superuser to create this extension.


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/service/server.py", line 1366, in preload_registries
    registry = Registry.new(dbname, update_module=update_module)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/decorator.py", line 232, in fun
    return caller(func, *(extras + args), **kw)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/tools/func.py", line 97, in locked
    return func(inst, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/modules/registry.py", line 129, in new
    odoo.modules.load_modules(registry, force_demo, status, update_module)
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/modules/loading.py", line 489, in load_modules
    processed_modules += load_marked_modules(env, graph,
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/modules/loading.py", line 365, in load_marked_modules
    loaded, processed = load_module_graph(
                        ^^^^^^^^^^^^^^^^^^
  File "/data/build/Gitlab Phileas Odoo 18.0/odoo/modules/loading.py", line 193, in load_module_graph
    getattr(py_module, pre_init)(env)
  File "/data/build/Gitlab Phileas Community 18.0/base_geoengine/geo_db.py", line 43, in init_postgis
    raise MissingError(
odoo.exceptions.MissingError: Error, can not automatically initialize spatial postgis support. Database user may have to be superuser and postgres/postgis extensions with their devel header have to be installed. If you do not want Odoo to connect with a super user you can manually prepare your database. To do this, open a client to your database using a super user and run:
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;