PostgreSQL

is Mio's module to configure PostgreSQL Databases.

Links

• Docs: https://www.postgresql.org/docs/current/
• Issues: https://www.postgresql.org/list/pgsql-hackers/
• Source: https://github.com/postgres/postgres
• License: PostgreSQL License

Config Files

Name	Default	Type	Description

• db-restore.pg
• db-restore-all.pg
• db-ls.pg
• db-eval.pg
• db-dump.pg
• db-create.pg
• db-backup.pg
• apt-key.asc

Use

---

TODO

• remove .pgpass
• use https://github.com/darold/pgbadger
• package https://github.com/KenanBek/dbui
• integrate https://www.drawdb.app/editor
• test pganonymize==0.12.0
• create database on remote hosts
• create with postgres or appadmin and grant usage
• split data and schema