A Debian LXC image containing the Prometheus Postgres Exporter.
Set /opt/postgres_exporter/.env accordingly
I run a Home Lab on Proxmox and my preference is to manage CTs rather than a VM or CT running Docker images (with something like Portainer).