From: | Perumal Raj <perucinci(at)gmail(dot)com> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | Sergei Kornilov <sk(at)zsrv(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Question about pg_upgrade from 9.2 to X.X |
Date: | 2019-03-07 05:44:16 |
Message-ID: | CALvqh4q=LOB6mMeyGKUiTL=8A6H5YSrm1eX=x53nEG-VzoFm9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Awesome, thanks Sergei and Justin,
Finally, I am able to upgrade the DB from 9.2 to 9.6 successfully after
dropping Schema (reorg) without library issue.
Also , I have installed -Contrib. package for Version:10 and upgraded to
version 10.7 too.
On both the cases , I have used --link option and it took just fraction of
seconds ( I feel 'Zero' Downtime effect )
Any pointers for pg_repack schema creation ?
Will there be any impact in the future , Since i used --link option ?
Regards,
Raju
On Tue, Mar 5, 2019 at 8:21 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> On Tue, Mar 05, 2019 at 08:09:12AM -0800, Perumal Raj wrote:
> > Thanks Sergei/Justin for the continues update.
> >
> > So reorg Schema might be created as part of some scripts prior to 9.2
> > Version ?
>
> I'm guessing they were probably created in 9.2.
>
> > These are the functions in DB not the Extension. However these functions
> > will not run as the associated libraries are not exists in System now
> (9.2)
> > and I hope no impact to system.
>
> I guess someone installed pgreorg, ran its scripts to install its functions
> into the DB, and then removed pgreorg without removing its scripts.
>
> > One Question need your address,
> >
> > Prior to 9.2 to 9.6 upgrade , I have tried 9.2 10.7 upgrade and failed
> > similar error(you can refer beginning o the post ).
> >
> > > 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
> >
> > These Extension seems to be standard. What is the use of these function
> and
> > do we have any alternative in Higher version or Enhanced object if i drop
> > it in 9.2 and continue upgrade to 10.7 Version.
>
> See Sergei's response:
>
> https://www.postgresql.org/message-id/7164691551378448%40myt3-1179f584969c.qloud-c.yandex.net
>
> You probably want to install this package for the new version (9.6 or 10 or
> 11).
>
> [pryzbyj(at)TS-DB ~]$ rpm -ql postgresql11-contrib |grep -E
> '(uuid-ossp|adminpack|hstore)\.control'
> /usr/pgsql-11/share/extension/adminpack.control
> /usr/pgsql-11/share/extension/hstore.control
> /usr/pgsql-11/share/extension/uuid-ossp.control
>
> Justin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Julie Nishimura | 2019-03-07 07:54:12 | partial data migration |
Previous Message | Thomas Munro | 2019-03-07 03:46:24 | Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2019-03-07 06:02:59 | Re: New vacuum option to do only freezing |
Previous Message | Masahiko Sawada | 2019-03-07 03:57:30 | Re: [HACKERS] Block level parallel vacuum |