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
Last activity: Jul 16, 2024, 12:13 AM