Category : command-line

I’m looking for the solution to how can I run manage.py dbshell in a virtual environment without error: CommandError: You appear not to have the ‘sqlite3’ program installed or on your path. I have installed Python in venv. I added the path to environment variables. I can populate db in the Django project, so it’s ..

Read more

I’m using win 10 64bit. I dump my data with pg_dump –column-inserts –data-only –no-owner –no-privileges –dbname=crm_db –schema=public –exclude-table=public."cmsArticle" –host=xxx –username=xxx –port=5432 -v –file=D:db_backupdump.sql I got a 20GB file, now I tried to restore with: psql -d crm_db –host=xxx.postgres.database.azure.com –username=xxx -p 5432 -v -f D:/db_backup/dump.sql And I see psql: warning: extra command-line argument D:/db_backup/dump.sql. Solution found: ..

Read more