From: Tom Lane <tgl@sss.pgh.pa.us>
To: Aaron Craig <mercutio@pobox.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trouble using plpgsql after 8.0 install
Date: Mon, 28 Feb 2005 15:20:30 -0500
Message-ID: <24900.1109622030@sss.pgh.pa.us> (raw)
In-Reply-To: <4222521F.5090309@pobox.com>
References: <4222521F.5090309@pobox.com>
Aaron Craig <mercutio@pobox.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, mercutio@pobox.com
Subject: Re: Trouble using plpgsql after 8.0 install
In-Reply-To: <24900.1109622030@sss.pgh.pa.us>
References: <4222521F.5090309@pobox.com> <24900.1109622030@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox