Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
LiangKuo
Contributor III
Contributor III

About POSTGRE database upgrade

大家好,我在升級POSTGRE資料庫的時候,遇到了一個狀況,例如附件。我需要檢查函數或設定檔才能知道(監聽位址)
(IP範圍)這兩個設定。

Labels (2)
3 Replies
sureshkumar
Support
Support

Hello @LiangKuo 

Looks like duplicate of post About POSTGRE database upgrade - Qlik Community - 2462796

 

Regards,
Suresh

raffas
Contributor
Contributor

If you can afford the downtime, pg_upgrade with the --link option is the fastest way to do the upgrade. It typically only takes minutes - the duration depends on the number of databases, not on their size.

gonilvo4
Contributor
Contributor

If you are not planning to use pg_upgrade, but rather pg_dump/pg_restore (e.g. because your database is small or you don't want to migrate all databases in the instance/cluster), then there is indeed no need to use pg_basebackup.