Thread: Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?
1.) During our prior upgrade process we used pg_upgrade to move from pg 8.4.3 to 9.1.6 using the hard links install option, we also have our data spread across disk storage mediums; fiber, nas. Are there any known issues, bugs with using pg_upgrade to move from 9.1.6 to pg 9.3?
2.) We also have to stand up a fresh install of pg 9.3 with postgis 2.1 and restore the data from a 9.1.6 dump. Are there any known issues, bugs with using pg_dump or pg_dumpall and then pg_restore to get this done?
thanks
2.) We also have to stand up a fresh install of pg 9.3 with postgis 2.1 and restore the data from a 9.1.6 dump. Are there any known issues, bugs with using pg_dump or pg_dumpall and then pg_restore to get this done?
thanks
On 9/20/2013 1:51 PM, fburgess@radiantblue.com wrote: > 1.) During our prior upgrade process we used pg_upgrade to move from > pg 8.4.3 to 9.1.6 using the hard links install option, we also have > our data spread across disk storage mediums; fiber, nas. Are there any > known issues, bugs with using pg_upgrade to move from 9.1.6 to pg 9.3? having multiple tablespaces on different mount points complicates things. I'm not sure how or if pg_upgrade handles that. -- john r pierce 37N 122W somewhere on the middle of the left coast
On Fri, Sep 20, 2013 at 02:00:05PM -0700, John R Pierce wrote: > On 9/20/2013 1:51 PM, fburgess@radiantblue.com wrote: > > 1.) During our prior upgrade process we used pg_upgrade to move from pg > 8.4.3 to 9.1.6 using the hard links install option, we also have our data > spread across disk storage mediums; fiber, nas. Are there any known issues, > bugs with using pg_upgrade to move from 9.1.6 to pg 9.3? > > > > having multiple tablespaces on different mount points complicates things. I'm > not sure how or if pg_upgrade handles that. pg_upgrade is fine with that. The old/new tablespaces stay in the same mount point as just per-version subdirectories. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +