PostgreSQL integration for dynamic secrets #657
Description
Describe the solution you'd like
Integrate with PostgreSQL datdabase to automate secret management. Create, manage, delete PostgreSQL roles as leases for each account in Phase on demand or async.
There will also be a need to make sure we have a connector or a gateway that Phase can use to make the database instance reachable externally for Phase Cloud or inside or a self-hosted instance.
There is a fair bit of complexity involved given that Phase will need to connect and interact with the database instance over TCP rather then HTTP.
Additional context
We could use the Phase CLI as a lightweight gateway to bridge connectivity, this will avoid a new asset and given the CLI is already packaged for the widest possible targets, the integration will be simpler.