Postgres collation error installing on OSX Ventura 13.4 M1 mac

[jolonbankey-AI]

While I was able to install 0.04 no problem, I am very excited for the updates in 0.06 but when I try to run the docker, I am getting this error:

WARNING: database "template1" has a collation version mismatch superagi-super__postgres-1 | 2023-06-30 01:57:18.329 UTC [34] DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.36.

[luciferlinx101]

can you delete Postgres volume and try again if the data is not important?

[jolonbankey-AI]

I just deleted the volumes from docker with the same result.

It actually runs, but keeps outputting the error in the terminal window.

[neelayan7]

Go inside Docker, Delete the currrent database, create a new database super_agi_main by going inside template0. This might resolve your issue since there is a collation issue with template1 and database.

[clappo143]

I'm facing this issue. Could you please explain how to create the new database from inside Docker