Date: Tue, 24 Nov 2015 16:39:04 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: 'Yogi Barot  *EXTERN*' <YBarot@symcor.com>,
 "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: Postgresql 9.4 pg_upgrade issues
Message-ID: <20151124213904.GA24342@momjian.us>
References: <6fb1f76dc5aa4d0a9285aa25ac099476@MX002.symprod.com>
 <A737B7A37273E048B164557ADEF4A58B50FEA5DF@ntex2010i.host.magwien.gv.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <A737B7A37273E048B164557ADEF4A58B50FEA5DF@ntex2010i.host.magwien.gv.at>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Tue, Nov 24, 2015 at 04:25:49PM +0000, Albe Laurenz wrote:
> Yogi Barot wrote:
> > I am running postgresql upgrade from postgresql 9.0.11  to postgresql 9.4 using pg_upgrade link method
> > and having some issues with upgrade on Reh hat 7.1.
> > 
> > Here is the error message, that I am getting via pg_upgrade:
> > 
> > /usr/pgsql-9.4/bin/pg_upgrade --old-bindir=/usr/local/pgsql/bin --new-bindir=/usr/pgsql-9.4/bin --old-
> > datadir=/opt/symcor-foa/data --new-datadir=/opt/symcor-foa/data94  -v --user=pg_foa_c  --link  -p 5432
> > -P 5433
> > 
> > cat  loadable_libraries.txt
> > Could not load library "/opt/symcor-foa/pgsql//lib/pgplsh/pgplsh.so"
> > ERROR:  could not load library "/opt/symcor-foa/pgsql//lib/pgplsh/pgplsh.so": /opt/symcor-
> > foa/pgsql//lib/pgplsh/pgplsh.so: undefined symbol: DirectFunctionCall1
> > 
> > In the original cluster, I have removed function and language which reference this library, I also
> > took postgres dump using pg_dumpall and it does not show any reference to this library plsh. Still
> > pg_upgarde somehow reference this library.
> > 
> > Any help greatly appricaited as I am stuck here, can not build library on new Rhel 7 cluster, we don’t
> > need library, but not sure how to remove the reference of it completely. I dropped from all databases
> > and even from template1 database using droplib plsh;
> 
> I guess you failed to remove PL/sh in the original cluster.
> 
> Did you try the following in all databases:
>    DROP LANGUAGE plsh CASCADE;
>    DROP FUNCTION plsh_handler();
>    DROP FUNCTION plsh_validator(oid);

I suggest you look in pg_proc with this query that pg_upgrade uses:
	
	SELECT DISTINCT proname, probin 
	FROM   pg_catalog.pg_proc 
	WHERE  prolang = 13 /* C */ AND 
	probin IS NOT NULL AND 
	oid >= 16384;

That should show the "pgplsh.so" reference.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin