Lemmy Cafe will be having its database upgraded.

Reasons

• Pict-rs is expecting PostgreSQL 16. It's running fine now, but it might not be at some future point.
• PostgreSQL 15 has a bug that requires jit to be turned off - otherwise DB keeps consuming all the memory available on the system and then some. In the end it gets culled by the kernel. This has performance as well as reliability issues. While turning jit off has remedied the constant failure, it has also made the database a bit slower. I prefer squeezing out as much performance as possible :)

Plan

• Point nginx to the maintenance page
• Shut down PostgreSQL 15
• Run the upgrade tool
• Start up PostgreSQL 16
• Point nginx to lemmy

Expected downtime

About an hour, if things go well. More if not so.

Will try to keep the maintenance page updated.

Here's the timezone converter