Re: best practices for dumping databases

------=_Part_10821_29603524.1207529375439
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
re****t 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@[EMAIL PROTECTED]
> wrote:

> "Mag Gam" <magawake@[EMAIL PROTECTED]
> 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
>

------=_Part_10821_29603524.1207529375439
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I am not able to reproduce this error now..strange!<br><br>I am running
8.3.0, and basically the error I was getting was &quot;\m ignoring&quot;
when I tried to do a restore. I was using the redirect &quot; psql foo
&lt; db.dump&quot; and the &quot;\i db.dump&quot; method for the restore.
<br>
I will be vigilant and try to attempt this again if I find anything I will
re****t it ASAP.<br><br>But, what is the correct practice to do db_dumps?
pg_dump db should suffice? <br><br>Thanks <br><br><br><div
class="gmail_quote">
On Sun, Apr 6, 2008 at 6:36 PM, Tom Lane &lt;<a
href="mailto:tgl@[EMAIL PROTECTED]
">tgl@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">&quot;Mag Gam&quot; &lt;<a
href="mailto:magawake@[EMAIL PROTECTED]
">magawake@[EMAIL PROTECTED]
>&gt; writes:<br>
&gt; What is the best way to dump a database?<br>
&gt; Currently, I am using pg_dump dbname. However, my data contains a lot
of<br>
&gt; escape sequences and various characters which is causing a restore
problem.<br>
<br>
</div>Please provide details --- it should work anyway, in any
remotely<br>
modern PG version.<br>
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;regards, tom lane<br>
</blockquote></div><br>

------=_Part_10821_29603524.1207529375439--