This message was deleted.

sparse-intern-71089

08/17/2022, 7:52 AM

This message was deleted.

gorgeous-country-43026

08/17/2022, 7:53 AM

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)."

gorgeous-country-43026

08/17/2022, 7:54 AM

Any tips and tricks would be appreciated

gorgeous-country-43026

08/17/2022, 10:56 AM

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

gorgeous-country-43026

08/17/2022, 10:56 AM

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

gorgeous-country-43026

08/17/2022, 10:56 AM

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

gorgeous-country-43026

08/17/2022, 10:57 AM

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

gorgeous-country-43026

08/17/2022, 11:29 AM

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

gorgeous-country-43026

08/17/2022, 11:45 AM

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

gorgeous-country-43026

08/17/2022, 11:46 AM

sigh

2 Views

Open in Slack

Previous Next

Pulumi Community

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.