3 ms·
Wondering why you couldn’t use in-place upgrade (pg_upgrade [0]). Not supported in Azure? [0] https://www.postgresql.org/docs/current/pgupgrade.html https://ww
by wrs 5y ago
Wondering why you couldn’t use in-place upgrade (pg_upgrade [0]). Not supported in Azure?
[0] https://www.postgresql.org/docs/current/pgupgrade.html https://www.postgresql.org/docs/current/pgupgrade.html
- majewsky 5y agoI'm guessing this would still take more than one hour since it needs to rewrite all (or most) of the 4TB?
- aidos 5y agoNot in my experience. You can use the —-link flag to get it to use hard links so it doesn’t need to move the data at all. Have been through this process myself a few times and it only took seconds on a 50-100GB db. I’m always a little surprised with how week it works.
- wrs 5y agoExactly, it just has to touch the metadata, unless the data page format has changed, which the developers try hard to avoid (successfully so far).