X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 10CC556600 for ; Mon, 28 Feb 2005 20:20:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40627-04 for ; Mon, 28 Feb 2005 20:20:32 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9E7A0565E4 for ; Mon, 28 Feb 2005 20:20:30 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1SKKU4l024901; Mon, 28 Feb 2005 15:20:31 -0500 (EST) To: Aaron Craig Cc: pgsql-admin@postgresql.org Subject: Re: Trouble using plpgsql after 8.0 install In-reply-to: <4222521F.5090309@pobox.com> References: <4222521F.5090309@pobox.com> Comments: In-reply-to Aaron Craig message dated "Mon, 28 Feb 2005 00:05:03 +0100" Date: Mon, 28 Feb 2005 15:20:30 -0500 Message-ID: <24900.1109622030@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/330 X-Sequence-Number: 16498 Aaron Craig writes: > I get this result: > ERROR: could not load library "/usr/lib/pgsql/plpgsql.so": > /usr/lib/pgsql/plpgsql.so: undefined symbol: PG_exception_stack This sounds like you are trying to load a newer plpgsql.so into an older backend. In the context of the update process you describe, I can't help wondering if you remembered to stop the old postmaster and start a new one. You could still be talking to the running old postmaster despite having deleted all its executable files from underneath it. (Recent RPMs include an auto postmaster stop when uninstalling the server package, but that wasn't always there.) Note that another important step missing from your description was dumping the old database so you could load it into the new postmaster. It'd be a good idea to run pg_dumpall before trying to shut down the old postmaster --- I'm not 100% sure that will work, but if it does, it will save you having to reinstall the old RPMs in order to dump your data. regards, tom lane