Re: problem with postgresql 7.2 recovery - Mailing list pgsql-admin

s.chava@wcom.com (Srinivasa Rao Chava) writes:
> Hi I have installed postgresql 7.2. I took the backup with pg_dumpall
> in postgresql7.1.3 and I tried to restore it in postgresql7.2 with the
> following command.

I think the thing you need to fix is:

> psql:pgbackups:80: ERROR:  stat failed on file
> '/u01/app/pgsql/7.1.2/lib/plpgsql.so': No such file or directory

Evidently your dump file contains a hard-coded reference to an old
directory path.  You'll need to edit that.  I recommend making it
refer to just 'plpgsql', no path, no ".so".

            regards, tom lane