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