provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

Support Azure Username Format

Open clementblaise opened this issue 3 years ago • 1 comments

What problem are you facing?

Azure Postgres instance connection string use a username formatted as <role_name>@<database_name>. This make it impossible to use the connection string directly since username returned is only the role name

How could Crossplane help solve your problem?

The role.postgresql.sql.crossplane.io resource could add an optional field for a user suffix and be use to template the correct connection string username

clementblaise avatar Jun 02 '22 14:06 clementblaise

The Azure docs suggest to escape the @ with %40: https://docs.microsoft.com/en-us/azure/postgresql/single-server/tutorial-design-database-using-azure-portal#connect-to-postgresql-database-using-psql

Does that work on your end?

Duologic avatar Jun 10 '22 12:06 Duologic