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 #postgresql people agree with that?
Setting up my Mastodon server made me think about #PostgreSQL availability and backups.
At the moment it's just a single database instance.
Harald's #pgconfeu 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.
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk
Time for a cuppa... Earl Grey please!