No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.

Pulumi Community

Any ideas how to create a Cloud SQL PostgreSQL instance with a database of a custom collation strictly through Pulumi?

One cannot set the `DatabaseInstance` collation to anything else than default and then `Database` creation fails since it is "is incompatible with the collation of the template database (en_US.UTF8)."

I've been banging my head to the wall with this seemingly simple problem but it looks like GCP Cloud SQL PostgreSQL just simply does not support other collates than en_US.utf8 *unless* you go in via psql and create the database there manually

But this is definitely not what I want to do, I want to control everything via Pulumi and IaC

And I don't want to expose my database to the public internet either

I must not be the first person to fight with this problem? How have people solved this?

Been googling around and it seems this is simply not possible without using a direct SQL query

Guess I'll just have to do this via kubernetes sidecar container execution