How to fix postgres collations in container? #9497
Unanswered
digdilem-work
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
After applying today's security patches, the logs show warnings like this. These seem to be things that should be addressed.
Can someone please give me a pointer in how to do this? There's no pgsql command available in the container, although there is a postgres user, and if spacewalk-sql is the tool, then I can't hit upon the right commands.
I was thinking something like this once I could get a db shell
\c uyuni
REINDEX DATABASE uyuni;
ALTER DATABASE uyuni REFRESH COLLATION VERSION;
\c reportdb
REINDEX DATABASE reportdb;
ALTER DATABASE reportdb REFRESH COLLATION VERSION;
Thanks
Beta Was this translation helpful? Give feedback.
All reactions