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