[EMAIL PROTECTED] (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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to