I am not able to reproduce this error now..strange!
I am running 8.3.0, and basically the error I was getting was "\m ignoring" when I tried to do a restore. I was using the redirect " psql foo < db.dump" and the "\i db.dump" method for the restore.
I will be vigilant and try to attempt this again if I find anything I will report it ASAP.
But, what is the correct practice to do db_dumps? pg_dump db should suffice?
Thanks
On Sun, Apr 6, 2008 at 6:36 PM, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
"Mag Gam" <
magawake@gmail.com> writes:
> What is the best way to dump a database?
> Currently, I am using pg_dump dbname. However, my data contains a lot of
> escape sequences and various characters which is causing a restore problem.
Please provide details --- it should work anyway, in any remotely
modern PG version.
regards, tom lane