Re: Question about pg_upgrade from 9.2 to X.X

Hi Sergei and Team Could you share your observation further. Perumal Raju On Thu, Feb 28, 2019, 11:21 AM Perumal Raj wrote: > here is the data, > > postgres=# \c template1 > You are now connected to database "template1" as user "postgres". > template1=# \dx > List of

Re: Question about pg_upgrade from 9.2 to X.X

here is the data, postgres=# \c template1 You are now connected to database "template1" as user "postgres". template1=# \dx List of installed extensions Name | Version | Schema | Description -+-++-- plpgsql

Re: Question about pg_upgrade from 9.2 to X.X

Hi > Yes, i want to get rid of old extension, Could you please share the query to > find extension which is using pg_reorg. pg_reorg is name for both tool and extension. Check every database in cluster with, for example, psql command "\dx" or read pg_dumpall -s output for some CREATE EXTENSION

Re: Question about pg_upgrade from 9.2 to X.X

Thank you very much Sergei, Yes, i want to get rid of old extension, Could you please share the query to find extension which is using pg_reorg. Regards, On Thu, Feb 28, 2019 at 10:27 AM Sergei Kornilov wrote: > Hello > > pgsql-hackers seems wrong list for such question. > > > could not

Re: Question about pg_upgrade from 9.2 to X.X

Hello pgsql-hackers seems wrong list for such question. > 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

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 wrote: > Hi > Please try with below

Re: Question about pg_upgrade from 9.2 to X.X

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

Question about pg_upgrade from 9.2 to X.X

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