Re: Migrating SQLite to Postgres

[Dale Bradman]

Having done a find for the manage.py file, it returned a number of results:

hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/conf/project_template/manage.py

hue/desktop/core/ext-py/django-axes-1.5.0/examples/example/manage.py

hue/desktop/core/ext-py/Django-1.6.10/django/conf/project_template/manage.py

hue/desktop/core/ext-py/Django-1.6.10/tests/admin_scripts/custom_templates/project_template/manage.py

hue/desktop/core/ext-py/Django-1.6.10/build/lib.linux-x86_64-2.7/django/conf/project_template/manage.py

hue/desktop/core/ext-py/django-openid-auth-0.5/example_consumer/manage.py

hue/desktop/core/ext-py/python-openid-2.2.5/examples/djopenid/manage.py

Which one do I use?

And to migrate is it as simple as doing:

$ manage.py migrate

Thanks,
Dale

On Monday, June 6, 2016 at 10:02:53 AM UTC+1, Dale Bradman wrote:

Hello,

I'm trying to migrate the SQLite database over to a Postgres database however I can no longer load the Hue UI.

When I run 

build/env/bin/hue syncdb --noinput

I see the following output:

Syncing...

Creating tables ...

Installing custom SQL ...

Installing indexes ...

Installed 0 object(s) from 0 fixture(s)

Synced:

 > django.contrib.auth

 > django_openid_auth

 > django.contrib.contenttypes

 > django.contrib.sessions

 > django.contrib.sites

 > django.contrib.staticfiles

 > django.contrib.admin

 > south

 > axes

 > about

 > filebrowser

 > help

 > impala

 > jobbrowser

 > metastore

 > proxy

 > rdbms

 > zookeeper

 > indexer

Not synced (use migrations):

 - django_extensions

 - desktop

 - beeswax

 - hbase

 - jobsub

 - oozie

 - pig

 - search

 - security

 - spark

 - sqoop

 - useradmin

 - notebook

(use ./manage.py migrate to migrate these)

When I restart the server (via runserver) I see the following error in the log output:

ProgrammingError: relation "desktop_settings" does not exist

LINE 1: ...e", "desktop_settings"."tours_and_tutorials" FROM "desktop_s...

Could you please help me finish the migration from SQLite to Postgres?

Thanks,

Dale