Hi, i want to create a new database in the postgres I created. I create a postgres provider and add the host as "postgresService.metadata.name". But when I run Pulumi up I get an error:

* Error connecting to PostgreSQL server postgres (schema: postgres): select tcp: search postgres: no such host

How to get a host in this case? How to make it work? I want to make the Postgres service unavailable to the public.