i want to migrate dtabase of Mayaan EDMS application from sqlit3 to postgresql
please help me if any one have suggesation to migrate the data from the database
You can use dumpdata and loaddata with django-admin or manage.py. Here is the reference from official docs django-admin and manage.py | Django documentation | Django
From where you are getting common_initial_setup, did you created a custom command if so then share that as well.
Also, share you traceback errors or code enclosed within bacticks.
i have already created a json floder with dumdata.json
Are you sure that you have created password root123 for the postgres user mayan. you should reset your postgres user mayan password once more and cross check everything.
i have checked several tims still i am getting the same error
One more thing I’ve found in your database settings is PORT is given in string remove single quotes use only numbers there and then try.
Check the PostgreSQL user mayan’s permissions in terminal. Is it same as default (user postgres).
Things you can try here:
-
Since you are connecting to a PostgreSQL instance on the same system, try removing the “HOST” and “PORT” keys from the DATABASES setting. This forces the client to connect using the local Unix domain socket.
-
Verify that your account can log in by using psql from the command line with the
-h localhostand-p 5432parameters. (e.g.,psql -u mayan -h localhost -p 5432)
If that fails, then it’s likely yourpg_hba.conffile needs to be adjusted.
Looking at these screen captures - it looks like you’re running VSCode on windows, but connecting to an Ubuntu instance? Please describe your development environment in a little more detail.