Question about pg_upgrade from 9.2 to X.X

From: Perumal Raj <perucinci(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Question about pg_upgrade from 9.2 to X.X
Date: 2019-02-28 18:13:58
Message-ID: CALvqh4rFnKbGOaHm0KdOZX67S=EKqvH69VxGSoue+qRqJJAREA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mahendra Singh 2019-02-28 18:22:47 Re: Question about pg_upgrade from 9.2 to X.X
Previous Message chiru r 2019-02-28 18:06:10 Re: Pgbackrest Comparability issue

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-02-28 18:15:40 Re: Drop type "smgr"?
Previous Message David Steele 2019-02-28 18:13:34 Re: Remove Deprecated Exclusive Backup Mode