If you're running the nostream relay and a recent version upgrade broke your relay database due to a postresql version mismatch, you can fix it with the following command:

docker compose exec nostream-db psql -U nostr_ts_relay -c "ALTER DATABASE nostr_ts_relay REFRESH COLLATION VERSION"

you'll need to do this while the database container is running (and erroring). you can do this in a second separate terminal window if you'd like to watch the errors stop after the command is ran. good luck.

Reply to this note

Please Login to reply.

Discussion

Wow so many developers on nostr

This one took me a minute when it happened. lol.

Nostream is amazingly stable though. Almost makes me forget it’s JavaScript. 🤣

Agree. It runs well for me. Always has.