Postgres的Django 1.8迁移错误

艾森·塔奇

我是Django的新手,正在尝试使用Django(1.8)在Postgre中创建表

以下是我的模特班

    class Student(models.Model):
        name = models.CharField(max_length = 50)
        degree = models.CharField(max_length = 50)
        numofsubs = models.IntegerField()
        namesofsubs= models.CharField(max_length = 50)
        details = models.CharField(max_length = 50)

class Meta:

      db_table = "student"

views.py

def addStudent(request):
    student = Student(name = request.name, degree = request.degree ,
     numofsubs = request.numofsubs , nameofsubs = request.nameofparams , details = request.details)
    student.save()
    print 'data saved'

经过这些更改后,当我尝试运行python manage.py migration时,我得到了 django.db.utils.ProgrammingError: permission denied for relation django_migrations

以下是堆栈跟踪

追溯(最近一次通话):在execute_from_command_line(sys.argv)中的文件“ manage.py”,第10行,文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/ execute_from_command_line Utility.execute()文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/core/management/ init ”中的第338行,“ core / management / init .py”,.py“,第330行,执行self.fetch_command(subcommand).run_from_argv(self.argv)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/core/management /base.py“,第390行,位于run_from_argv self.execute(* args,** cmd_options)文件” /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/core/management中/base.py“行执行输出= self.handle(* args,** options)中的441行,文件” /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/core /management/commands/migrate.py“,行处理程序中的第93行= MigrationExecutor(connection,self.migration_progress_callback)文件” /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/ db / migrations / executor.py”,第19行,initself.loader = MigrationLoader(self.connection)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/migrations/loader.py”,第47行,位于初始化self中.build_graph()文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/migrations/loader.py”,第180行,位于build_graph self.applied_migrations = records.applied_migrations ()在Applied_migrations的第60行中,文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/migrations/recorder.py”返回x的set(tuple(x))在self.migration_qs.values_list(“ app”,“ name”))中的文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/models/query.py”,线162,在ITERself._fetch_all()文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/models/query.py”,行965,在_fetch_all self._result_cache = list( self.iterator())文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/models/query.py”,行1220,在迭代器中用于编译器中的行。 results_iter():文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py”,第783行,在results_iter结果= self.execute_sql中(多)在“ execute_sql cursor.execute(sql,sql,sql / compiler.py”中的文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py”中,第829行参数)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/backends/utils.py”,第79行,在执行返回super(CursorDebugWrapper,self)中执行。 (sql,参数)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/backends/utils.py”,第64行,在执行返回self.cursor.execute(sql,参数)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/utils.py”,第97行,在退出six.reraise(dj_exc_type,dj_exc_value,traceback)文件“ /usr/lib/ckan/default/local/lib/python2.7/site-packages/django/db/backends/utils.py”,执行,第64行返回self.cursor.execute(sql,params)django.db.utils.ProgrammingError:关系django_migrations的权限被拒绝

settings.py有以下conf用于数据库连接

DATABASES = {
    'default': {
       # 'ENGINE': 'django.db.backends.sqlite3',
       # 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'abc',
        'USER': 'xyz',
        'PASSWORD': 'xxxxx',
        'HOST': 'localhost',
        'PORT': 5432,
    }
}

请指导我我的应用程序有什么问题。

谢谢

棕熊

可能是您需要允许用户使用Grands:

GRANT ALL ON DATABASE abc TO xyz;

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章