Skip site navigation (1) Skip section navigation (2)

Re: Trouble using plpgsql after 8.0 install

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aaron Craig <mercutio(at)pobox(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Trouble using plpgsql after 8.0 install
Date: 2005-02-28 20:20:30
Message-ID: 24900.1109622030@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Aaron Craig <mercutio(at)pobox(dot)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

In response to

pgsql-admin by date

Next:From: EnvbopDate: 2005-02-28 20:44:52
Subject: Database Name
Previous:From: Tom LaneDate: 2005-02-28 19:40:34
Subject: Re: PostgreSQL 8.0.1 compile success Regression Fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group