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 |