s(dot)chava(at)wcom(dot)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