Re: Question about pg_upgrade from 9.2 to X.X

Поиск
Список
Период
Сортировка
От Mahendra Singh
Тема Re: Question about pg_upgrade from 9.2 to X.X
Дата
Msg-id CAKYtNAovy9EzMANPKTnT0gXKJbLKEwEVRBtaPB7Oz=zTYZ8oxw@mail.gmail.com
обсуждение исходный текст
Ответ на Question about pg_upgrade from 9.2 to X.X  (Perumal Raj <perucinci@gmail.com>)
Ответы Re: Question about pg_upgrade from 9.2 to X.X
Список pgsql-hackers
Дерево обсуждения
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@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

В списке pgsql-hackers по дате отправления: