On the other hand, and especially if migrating from SQLite, there's typically not _that_ much data. Even hundreds of GBs would probably be okay? Drives are so fast these days. Would be interesting to benchmark.

▲

tracker1 3 days ago | parent [-]

Maybe that's fair... just feels like a pain when I want to update an app, I have to jump through a few hoops as opposed to just updating the PostgreSQL version in a docker-compose or k8s config.

Would be nice if PG could at least automagically forward update when it starts and a database is from a prior version.

	▲	WayToDoor 3 days ago \| parent \| next [-]
		https://github.com/pgautoupgrade/docker-pgautoupgrade
	▲	markusw 3 days ago \| parent \| prev [-]
		Yeah, totally agreed. I'll have to look into that. I've really enjoyed the stability of SQLite, down to the file format.