Hi! My team and I have been trying to figure out how we could set configuration parameters for specific roles and/or users using pgbedrock.
Given the documentation, and the code base, our take is that it is only possible to have pgbedrock run ALTER ROLE "{}" WITH "{}"; statements, not ALTER ROLE "{}" SET "{}"; ones.
Would the possibility to do this make sense or is there a better way to do this that doesn't involve manually connecting to our PG instances and manually configuring our users?
Need:
the possibility to set configuration parameters for roles and/or users.
Example use-case:
Setting different statement_timeout values for different users using pgbedrock.
Hi! My team and I have been trying to figure out how we could set configuration parameters for specific roles and/or users using pgbedrock.
Given the documentation, and the code base, our take is that it is only possible to have pgbedrock run
ALTER ROLE "{}" WITH "{}";
statements, notALTER ROLE "{}" SET "{}";
ones.Would the possibility to do this make sense or is there a better way to do this that doesn't involve manually connecting to our PG instances and manually configuring our users?
Need:
Example use-case:
Setting different
statement_timeout
values for different users using pgbedrock.