postgres users how-to

You can add users to your database by setting database configuration option: .spec.gcp.sqlInstances[].databases[].users[].name. Additional users needs to manually be given access to the database and table. Either directly or with Flyway or other database migration tools.

Names added must match regex: ^[_a-zA-Z][_a-zA-Z0-9]+$. Secrets is generated and mounted for each user.

Info

If you've deployed your application with an additional users, and then change name or remove the user from configuration, you need to manually delete the google-sql-<MYAPP>-<USER> secret:

bash

Examples

Adding two additional users

app.yaml

Your application will get two additional secrets created, with environment variables for each user. They will look something like this:

bash

Adding additional user with custom env var prefix

app.yaml

The secret will then contain environment variables like this:

bash