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.
