I ran into this problem a couple of days ago when I upgraded from 7.0.3 to 7.4.1.
I used the 7.4.1 pg_dumpall, but it created a dump file which tried to load the old plpgsql.so.
I had to fix the dump file manually before loading it into the new db. There were some other annoyances too, like the
7.4.1pg_dumpall dumping out CR in the file, and then the 7.4.1. psql comlained about it and told me to use \r
instead...I had to take out the "LOCATION" in create database too because it complained about "no such environment
variable".I guess pg_dumpall doesn't understand the differences between the different versions, so you always have to
checkthe dump file manually if you are changing version.
/M
----- Original Message -----
From: <lnd@hnit.is>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, January 21, 2004 11:29 PM
Subject: [GENERAL] Lost plpgsql function
> After copied pg database from one PC to another
>
> -I could not find plpgsql function(s) in the copied database.
> -had to instal plpgsql language handler again
>
> -whilst tables and data moved fine
>
> The copy included all under /cygwin/usr/local/pgsql/data and database was
> down while making a copy.
>
>
> What could I forget to copy as far plpgsql is concerned ?
> Are pgsql stored objects stored in the database itself (a table pg_proc,
> column prosrc)?
> Catalog tables like pg_proc are just a part of database cluster data files,
> aren't they?
>
> Thank you in advance, Laimis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>