Thanks Mahendra for quick response. I have followed same way, only difference i didn't bringup Source ( 9.2), But not sure how that will resolve libraries issue. All i tried with --check mode only
Thanks, On Thu, Feb 28, 2019 at 10:23 AM Mahendra Singh <mahi6...@gmail.com> wrote: > Hi > Please try with below commands. > > Let we want to upgrade v6 to v11. > Note: I installed my binary inside result folder. > > export OLDCLUSTER=./6_EDBAS/EDBAS/result > export NEWCLUSTER=./11_EDBAS/EDBAS/result > ./11_EDBAS/EDBAS/result/bin/pg_upgrade --old-bindir=$OLDCLUSTER/bin > --new-bindir=$NEWCLUSTER/bin --old-datadir=$OLDCLUSTER/bin/data > --new-datadir=$NEWCLUSTER/bin/data > > Note: old server should be in running state and new server should not be > in running state. > > Thanks and Regards > Mahendra > > On Thu, 28 Feb 2019 at 23:44, Perumal Raj <peruci...@gmail.com> wrote: > >> Dear SMEs >> >> I have finally decided to move forward after great hospitality in Version >> 9.2.24 :-) >> >> First i attempted to upgrade from 9.2.24 to 10.7, but its failed with >> following error during Check Mode. >> >> could not load library "$libdir/hstore": ERROR: could not access file >> "$libdir/hstore": No such file or directory >> could not load library "$libdir/adminpack": ERROR: could not access file >> "$libdir/adminpack": No such file or directory >> could not load library "$libdir/uuid-ossp": ERROR: could not access file >> "$libdir/uuid-ossp": No such file or directory >> >> Observation : the above Libraries are present in 9.2 whereas its mising >> in 10.7. So i decided to go with lower version. >> >> Second i tried to attempt to upgrade from 9.2.24 to 9.6.12,9.4,9.3 but >> its failed with following error during Check Mode. >> >> could not load library "$libdir/pg_reorg": >> ERROR: could not access file "$libdir/pg_reorg": No such file or >> directory >> >> Observation : In this case , pg_reorg is not present on both Source and >> Target . But strange its failing. >> >> >> Method Used : pg_upgrade >> >> Could you please share some light here to get rid of library issue . >> >> Thanks, in advance , >> Raju >> >>
