Other
Useful Articles for Version Upgrades
→ 日本語版を読むI found a useful article about PostgreSQL version upgrades, so I'm noting it here.
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?