PostgreSQL database configuration with ltree extension

posgresql_configuration_with_ltree.md

PostgreSQL database configuration with ltree extension

1. Install PostgreSQL database (apt install postgresql postgresql-contrib under Ubuntu)
2. Log in to the postgres account: sudo --login --user postgres
3. Start the PostgreSQL interactive terminal: psql
4. Create the database: postgres=# CREATE DATABASE my_database;
5. Create a user: postgres=# CREATE USER my_user WITH PASSWORD 'my_password';
6. Grant the user access to the database. postgres=# GRANT ALL PRIVILEGES ON DATABASE my_database to my_user;
7. Switch to the database: \connect my_database;
8. Enable ltree extension on the database: create extension ltree;
9. Exit psql: \q

For Django to create test databases you also need to do ALTER USER my_user CREATEDB; inside psql.

If you want to run DROP SCHEMA public and/or CREATE SCHEMA public; you must set the created user as owner of the schema with:

ALTER SCHEMA public OWNER TO my_user;`