Apparently it can't be done, you can only host your Postgres on an it's own subdomain, not on an arbitrary URL, to be accessible.