Manual install user creation script does not grant enough privileges for percentage based db rotation

[fredrik-dahlgren]

My homer install made using the manual install did not grant enough privileges to run percentage based db rotation. DBDropDays still worked as expected.

2024/11/22 10:02:00.096090 rotator.go:618: WARN pq: must be superuser or have privileges of pg_read_all_settings to examine "data_directory"
2024/11/22 10:02:00.096122 rotator.go:229: ERR Error getdb pq: must be superuser or have privileges of pg_read_all_settings to examine "data_directory"
2024/11/22 10:02:00.096137 rotator.go:267: ERR pq: must be superuser or have privileges of pg_read_all_settings to examine "data_directory"
2024/11/22 10:02:00.096208 rotator.go:518: ERR pq: must be superuser or have privileges of pg_read_all_settings to examine "data_directory"

I granted this permission and got a new error

2024/11/22 10:03:00.086734 rotator.go:618: WARN pq: must be superuser or have privileges of the pg_execute_server_program role to COPY to or from an external program
2024/11/22 10:03:00.086764 rotator.go:229: ERR Error getdb pq: must be superuser or have privileges of the pg_execute_server_program role to COPY to or from an external program
2024/11/22 10:03:00.086770 rotator.go:267: ERR pq: must be superuser or have privileges of the pg_execute_server_program role to COPY to or from an external program
2024/11/22 10:03:00.086832 rotator.go:518: ERR pq: must be superuser or have privileges of the pg_execute_server_program role to COPY to or from an external program

I then gave it superuser privileges and the issue was resolved.

[github-actions]

Your report is appreciated. Please star this repository to motivate its developers! ⭐