SQLlitedan ---> POSTSQL

 sqlite Post sql 2-qism 

sudo apt update
sudo apt install postgresql postgresql-contrib

____________________________________________________________________________________________

sudo service postgresql start
___________________________________________________________________________________________

sudo -i -u postgres
psql

CREATE USER "user" WITH PASSWORD 'password';
ALTER ROLE "user" SET client_encoding TO 'utf8';
ALTER ROLE "user" SET default_transaction_isolation TO 'read committed';
ALTER ROLE "user" SET timezone TO 'UTC';
CREATE DATABASE databasename OWNER "user";
GRANT ALL PRIVILEGES ON DATABASE databasename TO "user";

\q
exit
___________________________________________________________________________________________

pip install psycopg2-binary
___________________________________________________________________________________________

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'databasename',
        'USER': 'username',
        'PASSWORD': 'password',
        'HOST': 'localhost',
        'PORT': '5432', 
    }
}

___________________________________________________________________________________________

python manage.py makemigrations
python manage.py migrate
__________________________________________________________________________________________

python manage.py dumpdata > dp.json

 python maage.py migrate

_________________________________________________________________________________________

python manage.py loaddata dp.json

 python maage.py migrate