Yeah, I was going to mention, just upgrading between PG versions can be a bit of a pain. Dump/Restore really seems like a less than stellar option of you have a LOT of data. I mean you can stream through gzip/bzip to save space but still.

I often wish that Firebird had a license that people found friendlier to use as it always felt like a perfect technical option for many use cases from embedded to a standalone server. PG has clearly eclipsed it at this point though.

▲

markusw 3 days ago | parent [-]

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.