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 > >