Just change postgres service type to LoadBalancer, add port 5432 to ingress, and open the tunnel, for minikube it would be:
minikube tunnel