sensu / sensu-docs

Sensu documentation
https://docs.sensu.io
MIT License
41 stars 56 forks source link

Update PostgreSQL Datastore documentation for Postgre-15 compatibility #4163

Closed lspxxv closed 1 year ago

lspxxv commented 1 year ago

Description

We need to update postgres documentation here to include running the command below that will grant all privileges to the sensu user for the sensu_events db

Category

This is an issue with:

Affected pages

https://docs.sensu.io/sensu-go/latest/operations/deploy-sensu/scale-event-storage/

Expected behavior

Docs should include the command - GRANT ALL ON SCHEMA public TO sensu - for PostgreSQL-15 compatibility.

Current behavior

The current installation/configuration steps would only work for earlier versions of postgres

Corrections needed

Add GRANT ALL ON SCHEMA public TO sensu while interacting with the sensu_events db.

Error when necessary privileges are not applied.

"component":"ent-store","error":"error migrating database to latest version: Could not get DB version: ERROR: permission denied for schema public (SQLSTATE 42501)","level":"error","msg":"error opening postgres store, retrying..
jhenderson-pro commented 1 year ago

Confirmed the same behavior and the fix.