471,073 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

restoring pgdump file file from 7.2 branch to 7.4

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
2 2880
"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
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.

Similar topics

6 posts views Thread by Rajesh Kumar Mallah | last post: by
6 posts views Thread by Ferrari, Eduardo | last post: by
1 post views Thread by Luc Le Blanc | last post: by
3 posts views Thread by SI | last post: by
3 posts views Thread by rdemyan via AccessMonster.com | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
5 posts views Thread by Troels Arvin | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.