Skip to content
Hallway
0:00 / 0:00

#django#sqlite#postgres

Changing Database in Django on Live website,no data loss||UNICODEERROR :encode 'utf-8' error fixed!

from django import __help__

23 subscribers • 1 video on Hallway

YouTube
  • Recommended by 1 person: 1 on Stack Overflow and its sister sites.

Intermediate. Assumes working knowledge.

983 views5 years ago1 recommendation

Databases and dataWeb developmentPostgresSQLitePython

How to migrate a Django database from SQLite to PostgreSQL on a live website and resolve UnicodeDecodeError issues during dumpdata.

Hi there ! this video is for changing the database from sqlite3 to postgres , and encounting some big error doing the process . Hope this will help ! my first video so , please share it and comment your other errors ! sakshamfoundations.in/ the website i have shown ... and the i have answered the same on the stack overflow .. Thank You!

Why it's here

1 person recommends this

What people say. Recommended for resolving the UTF-8 UnicodeDecodeError when dumping data to migrate Django from SQLite to PostgreSQL.

Saikat Mukherjeeon Stack Overflow • Recommends

On “Changing Django development Database from the default SQLite to PostgreSQL”

when you are changing the database you might get a UNICODEERRO:'utf-8' UnicodeDecodeError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start byte After wasting more than 5 days I finally got the solution .. you will never got that accurate error in internet, I figured it out by myself . python manage.py dumpdata > datadump.json then change the database settings.py as per your desired database and then apply the following commands ... python manage.py makemigrations python manage.py migrate python manage.py loaddata datadump.json and then if u got the error I have mentioned earlier, please follow step by step guide : 1.Install notepad ++ 2.open your datadum.json…
9View the answer