Postgresql15 Django Setup

  CREATE DATABASE mydb;
  CREATE DATABASE test_mydb;
  CREATE USER me WITH PASSWORD 'password';
  -- Connect to mydb
  \connect mydb;
  -- AWS quirks
  GRANT me TO POSTGRES;
  -- Create a schema with me as owner
  CREATE SCHEMA my_schema AUTHORIZATION me;
  -- Create an extension
  CREATE EXTENSION postgis SCHEMA my_schema;
  -- Connect to test_mydb
  \connect test_mydb;
  -- Create a schema with me as owner
  CREATE SCHEMA test_schema AUTHORIZATION me;
  -- Create an extension
  CREATE EXTENSION postgis SCHEMA test_schema;

  GRANT ALL PRIVILEGES ON DATABASE my_db TO me;
  -- Settings recommended by Django doc
  ALTER ROLE me SET client_encoding TO 'utf8';
  ALTER ROLE me SET default_transaction_isolation TO 'read committed';
  ALTER ROLE me SET timezone TO 'UTC';