pg_restore error

Hi all,

When doing a pg_restore from a pg_dump of a database, I am seeing the
following error:
pg_restore: [archiver (db)] could not execute query: ERROR: stat failed on
file '/usr/local/pgsql-7.2/lib/plpgsql': No such file or directory

I am currently on 7.2.1 and the software location has changed (to
/usr/local/pgsql). And, further research shows that the pg_proc shows:
plpgsql_call_handler | 1 | 13 | f | t | f
| f | 0 | f | 0 | |
100 |
0 | 0 | 100 | plpgsql_call_handler |
/usr/local/pgsql-7.2/lib/plpgsql

This shows /usr/local/pgsql-7.2/lib/plpgsql for the "probin" column.

How should an update of software be handled as per pg_proc? I.E. should
all the locations recorded in pg_proc be updated to use the new location of
the pgsql software? Is there an update script that will do this already?

Are there other parts that will need updating due to the change in the
software (directory)?

Thanks,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
A wiki we will go...