To help out everyone else, this is designed for those working on PostgreSQL development. For anyone who is just using PostGres as part of their application, use normal PostGreSQL container.
What I'd really like is an image that mirrors extensions available on AWS Aurora. Supabase's is the only that has some parity as far as I know
So if I'm building Python application with Prometheus/RabbitMQ/PostGres that's used as part of my application, My docker compose has network, those 3 services + Python Dev Container and I just reference the hostname of the service in my Python application config (ENV VARS).