$ sudo -u postgres psql
postgres=# CREATE USER example WITH PASSWORD 'example';
postgres=# ALTER USER username WITH LOGIN PASSWORD 'new_password';
postgres=# GRANT ALL PRIVILEGES ON DATABASE example to example;
postgis is used as example
postgres=# CREATE EXTENSION IF NOT EXISTS postgis;
$ psql your_db_name < /path/to/dump.sql
use the following template in every Django projects postgres://username:password@hostname/db_name
To quit just type \q