Fixed using this
https://stackoverflow.com/questions/10757431/postgres-upgrade-a-user-to-be-a-superuser
On Thursday, April 11, 2019 at 10:05:58 AM UTC+6, Asif Saif Uddin wrote:
>
> facing this error even after creating hstore extension from pg shell and
> generated empty migrations for hstore:
>
> line 89, in __exit__
> raise dj_exc_value.with_traceback(traceback) from exc_value
> File
> "/usr/local/lib/python3.6/dist-packages/django/db/backends/utils.py", line
> 84, in _execute
> return self.cursor.execute(sql, params)
> django.db.utils.ProgrammingError: permission denied to create extension
> "hstore"
> HINT: Must be superuser to create this extension.
>
>
> the initial empty migration was modified to the following and regenerated.
> face error while migrating. created admin super user too. but still not
> working
>
> # Generated by Django 2.2 on 2019-04-11 03:42
>
> from django.db import migrations
>
> from django.contrib.postgres.operations import HStoreExtension
>
>
> class Migration(migrations.Migration):
> dependencies = [
> ]
>
> operations = [
> HStoreExtension(),
> ]
>
> db settings; saleor and postgres both user permission granted to saleor
> db from pg shell.
> DATABASES = {
> 'default': dj_database_url.config(
> default='postgres://saleor:saleor@localhost:5432/saleor',
> conn_max_age=600)}
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ee3ee0b7-0e4d-492a-97ff-66cab875ff2d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
