AAtsushi's Blog
Other

Useful Articles for Version Upgrades

→ 日本語版を読む

I found a useful article about PostgreSQL version upgrades, so I'm noting it here.

techblog.gmo-ap.jp

Need to check not just data, but also permissions and ownership.

Verification checkpoints were as follows:

Is the database timezone set to UTC+9?
Are there any differences in role permissions before and after data migration?
Are there any differences in database owner/encoding/access rights/database size before and after data migration?
Are there any differences in schema count/schema owner/access rights per schema before and after data migration?
Are there any differences in index count/index owner/access rights per index before and after data migration?
Are there any differences in table count/table owner/access rights per table before and after data migration?