boundary-reference-architecture How to access PostreSQL on AWS

Hi guys, in the re:Invent dedicated video @malnick mentioned Boundary-to-Postgres RDS usage. Is there an example somewhere of how to do that?

Mar 29 '21 17:03 forando

Hey there! You can use our built in postgres subcommand to fork psql under the hood: boundary connect postgres [flags|args].

See boundary connect -h for more info, thanks!

Mar 30 '21 15:03 malnick

Not sure if I got it right. I tried to add Boundary Postgres RDS as a host via Boundary Web Console (created separate host_set and target for it as well). Did not find where to put db password though. Am I supposed to pass it as an argument when connecting with the client? As of now when I run boundary connect postgres -username=boundary -target-id <dedicated_target> it gets timed out. I could not find any how-to documentation except ssh.

Mar 30 '21 20:03 forando

If you're getting a time out it's most likely due to the client not being able to access the worker or the worker not being able to access the target. Make sure your security groups/IP table rules allow connections between these entities.

If you have detailed log output, that would also be handy to see here. Upgrading to the latest 0.5 release will also give you event logs, which would be valuable for debugging here too.

Aug 09 '21 15:08 malnick