[GENERAL] pg_restore error

[Partners - Majolee InfoTech]

Hello,   We use i686 based linux RH9.0 system and our postgresql is 8.0.3   We use following command su -c '/usr/local/pgsql/bin/pg_dump -d -O -x [DBNAME] > [file withpath]' postgres to generate dump.   But while restoring it gives too many errors and that is because it uses $_$ for plpgsql function body separator which the pg_restore and psql [dbname] < [file] both does not seem to understand.   Any solution to this..?? Regards, Biren Shah Mihir Darji