This message was deleted.
# generals
sparse-intern-71089
09/21/2023, 9:41 PMThis message was deleted.
l
late-journalist-61387
09/21/2023, 9:45 PMI am using the Postgres
d
dry-keyboard-94795
09/21/2023, 9:49 PM(sorry, thought I'd replied in thread before).
Are there cases where the user will exist but not be owned by pulumi?
l
late-journalist-61387
09/21/2023, 9:51 PMnope really, however I am not doing just create user, I am creating the a postgress schema ( public schema) and extension:
Copy code
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";late-journalist-61387
09/21/2023, 9:52 PMcan I manage do these with pulumi-postgres library?
d
dry-keyboard-94795
09/21/2023, 10:00 PMExtensions, yes.
Looks like it can create the schema, but can't do tables if that's what you're looking for
l
late-journalist-61387
09/21/2023, 10:05 PMno, I do not want to do tables at this time
late-journalist-61387
09/21/2023, 10:07 PMthat is pretty cool that pulumi can handle everything
b
billowy-army-68599
09/21/2023, 10:10 PM
this’ll enable the extension https://www.pulumi.com/registry/packages/postgresql/api-docs/extension/
l
late-journalist-61387
09/21/2023, 10:13 PMthanks @billowy-army-68599 it help me a lot
late-journalist-61387
09/22/2023, 8:00 AMHi, I came across another problem.
I have changed my code to use your own postgress library, however the problem is that I am not able to set the postgress connection details programmable, in my scenario, I am going to
1. create RDS in AWS and store the password using the secret manager
2. after creation, get the password from the secret manager ( I find the secret resource with database tag )
3. create role and user with for new created RDS server
however the problem is there is not way ( at least not documented ) to set the host, username, password for the postgress server so I can connect to that and setup my Role and Schema.
late-journalist-61387
09/22/2023, 8:08 AM@dry-keyboard-94795 do you know the answer pls
d
dry-keyboard-94795
09/22/2023, 8:17 AMEvery provider will have a provider resource you can configure:
https://www.pulumi.com/registry/packages/postgresql/api-docs/provider/
l
late-journalist-61387
09/22/2023, 8:17 AMperfect
late-journalist-61387
09/22/2023, 8:17 AMThank you
d
dry-keyboard-94795
09/22/2023, 8:18 AMQuick overview of providers: https://www.pulumi.com/docs/concepts/resources/providers/
l
late-journalist-61387
09/22/2023, 8:25 AMNice, it works well. just to optimize my code, can you please see is this the only solution for me ?
I tried to get the connection details and username and password in nested way, is there anyway not to use apply?
https://jsfiddle.net/gvwuj46t/1/
d
dry-keyboard-94795
09/22/2023, 8:27 AMCan you paste somewhere else, like gist.github.com, please?
Jsfiddle is unusable on mobile
l
late-journalist-61387
09/22/2023, 8:28 AMa moment pls
late-journalist-61387
09/22/2023, 8:29 AMlate-journalist-61387
09/22/2023, 8:36 AMthe problem with this code is that when I run pulumi in previews, as it is in dry run mode, it does not detect the resources I want to manage, so it says that they will be deleted
d
dry-keyboard-94795
09/22/2023, 8:37 AMIt looks like you can get the secrets manager arn through the rds instance outputs: https://www.pulumi.com/registry/packages/aws/api-docs/rds/instance/#masterusersecrets_nodejs
dry-keyboard-94795
09/22/2023, 8:38 AMThis should remove the need for your lookup code
l
late-journalist-61387
09/22/2023, 8:39 AMohhh, that is amazing
late-journalist-61387
09/22/2023, 8:39 AMhowever for getting the host and port, I still need apply method
late-journalist-61387
09/22/2023, 8:39 AMright?
d
dry-keyboard-94795
09/22/2023, 8:40 AMThose are outputs on the rds instance also
dry-keyboard-94795
09/22/2023, 8:42 AMYou can pass those in directly to the postgres provider without going through
.applyl
late-journalist-61387
09/22/2023, 8:43 AMgreat, I will try and let you know the result
d
dry-keyboard-94795
09/22/2023, 8:44 AMYou won't need the isPreview check after those changes are made, too
l
late-journalist-61387
09/22/2023, 8:44 AMyes, my main problem is the isPreview function
late-journalist-61387
09/22/2023, 9:46 AMYour solutions works find and everything is successfully setup now.
Special Thanks for that, however there is still very tiny problem
• the problem is that when I get the value of root from secret manager, it is in json format, and I need to parse it with JSON.parse, however the value is pulumi.Output<string>. I have used the apply function now, is it correct?
https://gist.github.com/atazangene/b0cac09cbde0337d1ab57b24f396bd9c
d
dry-keyboard-94795
09/22/2023, 10:04 AMYep, this is the way to do it
l
late-journalist-61387
09/22/2023, 10:04 AMGreat, Thank you
d
dry-keyboard-94795
09/22/2023, 10:05 AMApply is to let you do this kind of transform. You'll likely use it for building ARNs or policy documents
🙌 1