Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
大家好,我在升級POSTGRE資料庫的時候,遇到了一個狀況,例如附件。我需要檢查函數或設定檔才能知道(監聽位址)
(IP範圍)這兩個設定。
Hello @LiangKuo
Looks like duplicate of post About POSTGRE database upgrade - Qlik Community - 2462796
Regards,
Suresh
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.
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.