Sample Header Ad - 728x90

Issue with postgre database creation in Kali Linux

-3 votes
1 answer
593 views
I just installed postgresql 16 on my Kali Linux. It's working perfectly but when I try to create a database (using the correct command line), it gives me this feedback :
postgres=# create database Danny;
ERROR:  template database "template1" has a collation version mismatch
DETAIL:  The template database was created using collation version 2.37, but the operating system provides version 2.38.
HINT:  Rebuild all objects in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
I want to know how to solve this error and continue with database creation in postgre. How can I rectify this problem?
Asked by Daniel NanaYaw Gyamfi (9 rep)
Jul 15, 2024, 10:01 AM
Last activity: Jul 16, 2024, 12:13 AM