By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,691 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,691 IT Pros & Developers. It's quick & easy.

restoring pgdump file file from 7.2 branch to 7.4

P: n/a
Hello everyone:

I am attempting to upgrade from 7.2 to 7.4 Postgresql. I have
successfully installed 7.4 and am attempting to use the pgdump from 7.2
for 7.4. I'm having only one slight error that I would like some help
with.

I create both the pgsql and pltcl languages. I get two messages that I
don't understand. The first is a warning from the pgsql with reads:

changing return type of function plpgsql_call_handler from opaque to
language_handler. Does this matter?

The other error message is could not load library
/usr/lib/pgsql/pltcl.so: /usr/lib/pgsql/pltcl.so: undefined symbol: elog
function pltcl_call_hander() does not exist.

I am sure that the pltcl.so is in the correct location. Would the
version issue of pltcl.so matter? I'm using the pltcl.so from my older
7.2 branch.

Thanks!

Bob Powell
Database Administrator

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Bob Powell" <bo*@hotchkiss.org> writes:
I am sure that the pltcl.so is in the correct location. Would the
version issue of pltcl.so matter? I'm using the pltcl.so from my older
7.2 branch.


Can't do that.

In current releases it's considered bad practice to be using absolute
paths for .so's at all --- better to make them relative to $libdir so
that your function definitions are more portable.

What I'd recommend is that you create the database, use the new
version's "createlang" to install the PLs you want, and then run the
restore script and ignore its bleats about the PL objects already
existing. This will get you a modern definition of the PLs together
with your existing data.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

P: n/a
Am Freitag, 5. November 2004 16:29 schrieb Bob Powell:
changing return type of function plpgsql_call_handler from opaque to
language_handler. Does this matter?
Yes, but it's good that it happens. :)
I am sure that the pltcl.so is in the correct location. Would the
version issue of pltcl.so matter? I'm using the pltcl.so from my older
7.2 branch.


That doesn't work. You need to use the one that was compiled for the server
that you are using. You may need to adjust the path in the dump file.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.