Hello, we are using Pulumi to setup a postgresql s...
# general
h
Hello, we are using Pulumi to setup a postgresql server in azure, using C#. We have managed to create the server etc. but we have not found a good way to create certain users for a given database within the server other than using the psql cli via the
Pulumi.Command.Local.Command
class, which will be called every time a release is done and thus fail if the user already exist. Is there any good way to create a user for a postgresql database via. Pulumi ?
f
There is a PostgreSQL provider which will probably fit your use-case: PostgreSQL | Pulumi Registry
I use the mssql provider in my setup. It’s not always great if you are using virtual networks or IP whitelist, but it beats having to install a local command and manage update/diff/delete yourself.
h
ok, thanks @full-hydrogen-5950