Re: best practices for dumping databases

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Mag Gam" <magawake(at)gmail(dot)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
>