Re: pg_restore error

Laurette Cisneros <laurette@nextbus.com> writes:
> 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:
> 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?

The preferred contents of probin are now like
    $libdir/plpgsql
(the dollar sign is literal text here).  As of 7.2 the server will
substitute a suitable directory name for "$libdir".  You probably
have a database that was reloaded from an old dump without taking
advantage of this feature --- before 7.2 you could only use an
absolute path in probin.  Now, absolute paths are deprecated for exactly
the reason that they make version updates hard.

Note the lack of a ".so" in that probin entry, too.  This is also
a recommended new practice in 7.2 --- no reason to put
platform-dependent assumptions about shared library extensions into
your dumps.

            regards, tom lane