Idk maintaining the PG vector extensions has been kind of a pain in the ass, at least from an automation perspective

Huh? What are you maintaining? The PostgreSQL db and extensions are provided in the container image. You do not have to use your own external PostgreSQL.

Of course, you may have reasons to do that. But then you also own the maintenance.

I have never had to maintain any PG extensions. Whatever they put in the image, I just run. And so far it has just worked. Upgrades are frequent and nothing has broken on upgrade - yet at least

I never had to meddle with that