I've always considered applications using the 'postgres' default database not to be best practice, especially when they are authing as the 'postgres' user.

Do other people agree with that?

Setting up my Mastodon server made me think about availability and backups.

At the moment it's just a single database instance.

Harald's talk on Reasonable Availability, did a great job in explain that we don't always need the complexity.

However it prompted me to think that there are many times where sensible backups probably should be the first port of call rather than availability.

Mastodon

Time for a cuppa... Earl Grey please!