the first rule of database management is to not host or manage your database unless you are willing to pay someone to do it full time

can you share what are the common pitfalls with self hosting a postgres image, as I'm planning to do? I know self hosting will bite my ass sooner than later, I just want to be somewhat ready and prevent easy mistakes