The second part of the series on a shared PostgreSQL for a home server. We create a dedicated, minimally privileged user and database in pgAdmin for a specific application, connect Authentik to the shared database instead of its own container, and cover basic maintenance - VACUUM, ANALYZE, REINDEX, and when you actually need to do any of this by hand.
A detailed guide to installing and configuring Nextcloud in an LXC container - MariaDB as shown in the video (with an external PostgreSQL option), optional data on an NFS share, PHP-FPM/OPCache/APCu/Redis, live updates via notify_push, and the Memories photo gallery with video transcoding.
A detailed guide to installing and configuring PostgreSQL on a server. Covers installation steps, creating users and databases, setting up backups, and basic security for stable and reliable operation.
