Postgres issue mismatch

I have tried to install openvas on kali purple and having issues getting the fix to work. Any help would be great. Below is the error i get. I have tried to run gvm still but no success.

WARNING: database “postgres” has a collation version mismatch
DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.40.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
ERROR: The Postgresql DB does not exist.
FIX: Run ‘sudo runuser -u postgres – /usr/share/gvm/create-postgresql-database’

There are many references on how to fix this error on the forum. Here is a link to the Greenbone Community guide about this error.

1 Like

In my case, this commands worked

sudo -u postgres psql -d postgres -c 'ALTER DATABASE postgres REFRESH COLLATION VERSION;'
sudo -u postgres psql -d gvmd -c 'ALTER DATABASE postgres REFRESH COLLATION VERSION;'