This PR extends our service stack with PgAdmin (so our handymen can easily fix Odoo data when needed) and also brings in quite a few improvements.
PgAdmin. systemd service to run the PgAdmin Web UI, including daemon user, zero-config DB init with automatic connection to Postgres from the Web UI, and secure handling of PgAdmin Web UI admin password.
Nginx. Extended to make it work as a TLS reverse proxy for PgAdmin, routing traffic to /pgadmin.
DB Init Scripts. Scripts to initialise the Postgres, Odoo and PgAdmin DBs so the respective services can work out of the box without any extra manual config.
Vault. Improved interface with assertions and now catering for different config scenarios when only some of the secrets are required. Extended to cater for the PgAdmin Web UI admin password too.
User and DB names. PgAdmin, Odoo and system admin names are fully configurable now. Ditto for PgAdmin and Odoo DB names.
Docs. Updated to cater for the new PgAdmin functionality and extended with a brand new section about the database.
This PR extends our service stack with PgAdmin (so our handymen can easily fix Odoo data when needed) and also brings in quite a few improvements.
systemd
service to run the PgAdmin Web UI, including daemon user, zero-config DB init with automatic connection to Postgres from the Web UI, and secure handling of PgAdmin Web UI admin password./pgadmin
.