[Bug]: Database Error

[rich-user]

What happened?

PortNote PostgreSQL Database Log Error

Steps to reproduce

Go to docker logs for database:

2025-09-09 18:57:12.665 UTC [37] WARNING: database "portnote" has a collation version mismatch
2025-09-09 18:57:12.665 UTC [37] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
2025-09-09 18:57:12.665 UTC [37] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE portnote REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

I can't connect to fix? Any ideas?

Operating System

Windows

Version

1.2.0

Logs

2025-09-09 18:57:02.682 UTC [1] LOG:  starting PostgreSQL 17.6 (Debian 17.6-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit 
2025-09-09 18:57:02.682 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432 
2025-09-09 18:57:02.682 UTC [1] LOG:  listening on IPv6 address "::", port 5432 
2025-09-09 18:57:02.690 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 
2025-09-09 18:57:02.697 UTC [28] LOG:  database system was shut down at 
2025-09-09 18:57:02 UTC 2025-09-09 18:57:02.703 UTC [1] LOG:  database system is ready to accept connections 
2025-09-09 18:57:12.665 UTC [37] WARNING:  database "portnote" has a collation version mismatch 
2025-09-09 18:57:12.665 UTC [37] DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.41. 
2025-09-09 18:57:12.665 UTC [37] HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE portnote REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

### Additional Information

psql -h localhost -p 5432 -U postgres

psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", no encryption

[rich-user]

In case anyone else has the same issues - Connect to the container console as root:

psql -d "DB-Name" -U "Username"

root@portnote-db:/# psql -d portnote -U portnoteuser

portnote=# ALTER DATABASE portnote REFRESH COLLATION VERSION;
NOTICE: changing version from 2.36 to 2.41
ALTER DATABASE
portnote=# ALTER DATABASE postgres REFRESH COLLATION VERSION;
NOTICE: changing version from 2.36 to 2.41
ALTER DATABASE
portnote=# ALTER DATABASE template1 REFRESH COLLATION VERSION;
NOTICE: changing version from 2.36 to 2.41
ALTER DATABASE
portnote=# REINDEX DATABASE portnote
portnote-# \q

This fixed the issue of the portnote-db log filling up.