I played around with some lesser-known/used systemd features and put together an "on-demand PostgreSQL" setup: https://codeberg.org/TobiX/on-demand-postgres (will even shut down after 5 minutes idle timeout)