HiPlease 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/resultexport 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/dataNote: old server should be in running state and new server should not be in running state.Thanks and RegardsMahendraOn Thu, 28 Feb 2019 at 23:44, Perumal Raj <perucinci@gmail.com> wrote:Dear SMEsI 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 directorycould not load library "$libdir/adminpack": ERROR: could not access file "$libdir/adminpack": No such file or directorycould not load library "$libdir/uuid-ossp": ERROR: could not access file "$libdir/uuid-ossp": No such file or directoryObservation : 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 directoryObservation : In this case , pg_reorg is not present on both Source and Target . But strange its failing.Method Used : pg_upgradeCould you please share some light here to get rid of library issue .Thanks, in advance ,Raju
Dear SMEsI 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 directorycould not load library "$libdir/adminpack": ERROR: could not access file "$libdir/adminpack": No such file or directorycould not load library "$libdir/uuid-ossp": ERROR: could not access file "$libdir/uuid-ossp": No such file or directoryObservation : 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 directoryObservation : In this case , pg_reorg is not present on both Source and Target . But strange its failing.Method Used : pg_upgradeCould you please share some light here to get rid of library issue .Thanks, in advance ,Raju
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных