This message was deleted.
s
This message was deleted.
b
If you're using MySQL, you can use our MySQL provider to create users: https://www.pulumi.com/docs/reference/pkg/mysql/user/
So you don't need to touch SQL
r
This sounds great! Ah, so the
Role
resource takes care of the DB user creation. (PostgreS btw)
b
My experience with Postgres without Pulumi was it was users, but I'll check that for you.
r
It seems to be "Role" indeed. This threw me off a bit but now I am starting to get it. Thanks a lot Piers 🙂
b
🙂
r
A bit stuck. When provisioning on Azure, e.g.
Copy code
var server = new Azure.PostgreSql.Server...;
var pgDatabase = new Database(...);
Here I need to switch to the Pulumi.PostgreSql package // but how do I configure the lib? I cannot bridge the gap between the Azure DB server resource and the types of
Pulumi.PostgreSql
. It seems that explicit configuration is required. The best I came up with is
Pulumi.PostgreSql.Config.Host = "hostname"
but this seems to be ignored and a connection attempt against localhost is being made.
b
Take a look at the
Provider
docs: https://www.pulumi.com/docs/reference/pkg/postgresql/provider/ I think that's how you connect
r
@brave-planet-10645 I would love to pass you (at least) a beer, thanks a lot! This did it. : ))
I need to figure out why I cannot use the
Azure.Postgres
Outputs for the
Pulumi.Postgres
Inputs (transforms with Apply result in no meaningful values etc). Will keep fighting, but the user is created /flex
b
Glad it all worked 🙂
r
Is there a place where I can contribute with some C# samples? Once I figure the issue with the input / output values, I would love sum it up and throw it at github or some other place. Is there a place for potentially low quality community samples that could use some improvements? 🙂
b
We have the examples repo that you can submit PRs to
r
Oh alright, so I can also submit directly to it. Great! Have a nice day 🙂
b
You too