General Lemmy.Cafe

The upgrade has gone through smoothly and everything seems to be running smoothly.

The performance looks to be better on the backend, time will tell if the memory leak issue is actually solved. So far, though - so good!

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

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

The process went through smoothly. I have also used the opportunity to split up a singular lemmy container into individual tasks - this has enabled a seemless upgrade process with no downtime, bar a few process quirks I need to work out.

There have been some federation fixes merged into this release, so the situation should definitely be improving overall!

I will make a more detailed write up of the whole setup later on, other admins might find it useful. Or not.

The process went through smoothly. I have also used the opportunity to split up a singular lemmy container into individual tasks - this has enabled a seemless upgrade process with no downtime, bar a few process quirks I need to work out.

There have been some federation fixes merged into this release, so the situation should definitely be improving overall!

I will make a more detailed write up of the whole setup later on, other admins might find it useful. Or not.

May your families grow strong and your presents plentiful!

May your families grow strong and your presents plentiful!

The upgrade has reset the JWT, so you'll have to login again on your device as well as set up 2FA again.

Enjoy the new features!

The upgrade has reset the JWT, so you'll have to login again on your device as well as set up 2FA again.

Enjoy the new features!

Pun intended 😁

Just wanted to reiterate, my stance hasn't changed since last declaration.

If facebook starts funny business with extra domains - those will be added asap.

Pun intended 😁

Just wanted to reiterate, my stance hasn't changed since last declaration.

If facebook starts funny business with extra domains - those will be added asap.

It's been a long one, but finally the database is clean. In the end the cleanup took <20 minutes, but getting to it took me most of the weekend.

Sorry about flaky performance, it should be back to normal.

It's been a long one, but finally the database is clean. In the end the cleanup took <20 minutes, but getting to it took me most of the weekend.

Sorry about flaky performance, it should be back to normal.

Migrated email into a dedicated self-managed solution, but it was at the end of the month, haven't included it here.

Income

• LiberaPay: £11.41

Expenses

• Servers: £28.85

Month balance

• -£17.44

Previous balance

• -£44.66

Balance to date

• -£62.1

Migrated email into a dedicated self-managed solution, but it was at the end of the month, haven't included it here.

Income

• LiberaPay: £11.41

Expenses

• Servers: £28.85

Month balance

• -£17.44

Previous balance

• -£44.66

Balance to date

• -£62.1

Minor update in prep for the biggin. Pictrs was also pushed up to 0.4.4

Minor update in prep for the biggin. Pictrs was also pushed up to 0.4.4

The main feature being a fix the really nasty libwebp vulnerability.

The main feature being a fix the really nasty libwebp vulnerability.

I've just received an email that has links to what looks like some polish url redirect site. I suspect this is limited to admins as, by default, lemmy does not come with an email service.

Needless to say - don't click random links!

Stay safe, peeps!

I've just received an email that has links to what looks like some polish url redirect site. I suspect this is limited to admins as, by default, lemmy does not come with an email service.

Needless to say - don't click random links!

Stay safe, peeps!

I'm chuffed to bits to have finally had enough time to set it up externally. Google is no longer outright rejecting us!

And by externally I don't mean succumbing to the behemoths - it's all self managed!

I've seen a post recently about someone struggling hosting Lemmy on DigitalOcean and sending out verification emails. If you need help with config or would like to simply use lemmy.cafe's setup - feel free to reach out!

I'm chuffed to bits to have finally had enough time to set it up externally. Google is no longer outright rejecting us!

And by externally I don't mean succumbing to the behemoths - it's all self managed!

I've seen a post recently about someone struggling hosting Lemmy on DigitalOcean and sending out verification emails. If you need help with config or would like to simply use lemmy.cafe's setup - feel free to reach out!

First donations!

Also migrated pictrs from file to object storage, but have not been invoiced, yet. I suspect it's the low amount (<$1) and will probably keep carrying over until some threshold is reached.

Income

• LiberaPay: £15.26

Expenses

• Servers: £24.75

Month balance

• -£9.49

Previous balance

• -£35.17

Balance to date

• -£44.66