Set role or database parameters

[Andersson007]

Discussed in https://github.com/ansible-collections/community.postgresql/discussions/576

^{Originally posted by ivanov17 September 5, 2023} Hello! What is the best way to set role or database parameters?

There is the community.postgresql.postgresql_set module that uses ALTER SYSTEM to set PostgreSQL server configuration parameters.

Unfortunately, I don't see anything like this for altering role or database parameters.

Is using SQL queries with community.postgresql.postgresql_query currently the only option for this? Or maybe there are some other options that I didn't notice?

Are there plans to implement other *_set modules such as postgresql_user_set and postgresql_db_set?

[Andersson007]

See the discussion comment to get examples of what the reporter wants to achieve. Help wanted.

[optica-phoffmann]

@Andersson007 Looks like links (discussion and comment) do not work anymore.

[Andersson007]

@optica-phoffmann hi, thanks for pinging! here it is. Also there's a quick-start dev guide which can help