Project

General

Profile

Support #40873

erreur sur création de base : Must be superuser to create this extension

Added by Thomas Noël 2 months ago. Updated 2 months ago.

Status:
Résolu (à déployer)
Priority:
Normal
Assignee:
Target version:
-
Start date:
21 Mar 2020
Due date:
% Done:

0%

Patch proposed:
No
Planning:
No

Description

En mode packagé, sur une base vierge, erreur lors du zoo-manage create_tenant -v3 zoo-preprod-moncompte.nanterre.fr :

=== Creating schema zoo_preprod_moncompte_nanterre_fr
=== Running migrate for schema zoo_preprod_moncompte_nanterre_fr
Operations to perform:
  Apply all migrations: admin, auth, common, contenttypes, sessions, zoo_data, zoo_meta, zoo_nanterre
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying common.0001_initial... OK
  Applying common.0002_auto_20160105_1702... OK
  Applying sessions.0001_initial... OK
  Applying zoo_meta.0001_initial... OK
  Applying zoo_meta.0002_auto_20161214_1545...CommandError: tenant creation failed (permission denied to create extension "pg_trgm" 
HINT:  Must be superuser to create this extension.
)

Déjà rencontrée avec l'activation de la recherche Combo ; retrouver comment on gère ça.

History

#1 Updated by Thomas Noël 2 months ago

  • Status changed from Nouveau to Résolu (à déployer)

Sur le postgresql, le temps de la construction du tenant :

alter user zoo with superuser;

et ensuite

alter user zoo with nosuperuser;

À documenter pour la prod.

Also available in: Atom PDF