pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <24900.1109622030@sss.pgh.pa.us>
Permalink:  ../24900.1109622030@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/24900.1109622030@sss.pgh.pa.us

 · 

reply

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