Enable pg_stat_statements?

[edbizarro]

There is a way to enable pg_stat_statements? This extension required an extra config pg_stat_statements.track = all but I can't find a way to do this in the yml

[gclough]

You will need to enable it in shared_preload_libraries:

  postgresql_shared_preload_libraries:
    - "pg_stat_statements"

And then add it as an extension:

  postgresql_database_extensions:
    - db: postgres
      extensions:
        - pg_stat_statements

If you're wanting to add extra parameters to the postgresql.conf... I'm not sure there is a way to do that. It would need to be added to the templates/postgresql.conf-{{ postgresql_version }}.j2 file, which is the source for all postgresql.conf settings.

[gclough]

This will get fixed by #277

[attenzione]

Would be nice to see it in a release. #277 is open too long 😢

[github-actions[bot]]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

[github-actions[bot]]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.