[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]