mike g mentioned : => That could be a bug. How are you dumping the data? pg_dump? Select => query? How are you restoring the data? psql?
Dumping:
pg_dump -Ft | gzip > dump.tgz
Restoring:
zcat dump.tgz | pg_restore -Ft |psql
OR
tar xvfz dump.tgz
perl -pi -e 's/\$\$PATH\$\$/$ENV{PWD}/g' restore.sql
psql -f restore.sql
Both these methods, produce the same result.
pgpktvHaPxPHz.pgp
Description: PGP signature
