HELP! N8N POSTGRES START FAILING FROM NOWHERE
wayoalamos
PROOP

a month ago

i see this error in railway using n8n template:

2025-10-29 23:27:50.226 UTC [58272] WARNING: database "railway" has a collation version mismatch

2025-10-29 23:27:50.226 UTC [58272] DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.

2025-10-29 23:27:50.226 UTC [58272] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE railway REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

(postgress error) how can i fix this??

I didn't to anything, randomly just start failing! Weird!!! I need help, i have 100K daily users depending on this service!!!

HELP!!

$10 Bounty

3 Replies

Railway
BOT

a month ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

samgordon
PROTop 5% Contributor

a month ago

Have you run ALTER DATABASE railway REFRESH COLLATION VERSION as described in the error?

samgordon
PROTop 5% Contributor

a month ago

If you need help doing that:

Make a backup before continuing.

  • Install the Railway CLI

  • Right click the Postgres database

  • Copy the SSH command

  • Paste it into your terminal

  • Type psql and press enter

  • Type ALTER DATABASE railway REFRESH COLLATION VERSION;

Loading...