Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
LiangKuo
Contributor III
Contributor III

About POSTGRE database upgrade

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

Labels (3)
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.