search

MigOpsRepos / credcheck

PostgreSQL plain credential checker
MIT License
57 stars 5 forks source link

pg_password_history and pgbackrest #32

Closed glushakov closed 5 months ago

glushakov commented 6 months ago

Hi. When using password reuse policy with pgbackrest, in log files appears: WARN: invalid page checksum found in file /var/lib/pgsql/16/data/global/pg_password_history at page 0 and in summary info: "error(s) detected during backup" which really confused. Is there any way to avoid this? pgbackrest-2.51 , credcheck 2.6

darold commented 6 months ago

The only way is to move the password history file elsewhere than in the global sub-directory. Actually I had always though that this was a very bad idea to store this file there, but it appears to me that it should be the best place to write it. No I know I was first right :-D I will move it to PGDATA directly.

glushakov commented 6 months ago

Thanks a lot!

darold commented 6 months ago

Commit 3d83c51 fix this issue.

glushakov commented 5 months ago

Please tell, when we can expect a release with this fix?

darold commented 5 months ago

Release v2.7 published.