Re: Question about pg_upgrade from 9.2 to X.X

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 <mahi6run(at)gmail(dot)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 <perucinci(at)gmail(dot)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
>>
>>