supabase/analytics container is trying to connect to the supabase database as supabase_admin user.
pigsty doesn't include an pg_hba.conf entry for this out of the box which I believe is a mistake?
I added an entry to pigsty.yml manually and reconfigured the cluster which fixed the issue for me.
22:49:16.549 [error] Postgrex.Protocol (#PID<0.6035.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) no pg_hba.conf entry for host "PUBLIC_IP_REDACTED", user "supabase_admin", database "supabase", no encryption