[no subject]

       To dump a database:

       $ pg_dump mydb > db.out


       To reload this database:

       $ psql -d database -f db.out


       To dump a database called mydb to a tar file:

       $ pg_dump -Ft mydb > db.tar


       To reload this dump into an existing database called newdb:

       $ pg_restore -d newdb db.tar


Have you tried to dump the database this way? Does it work?

t.n.a.

------=_Part_14521_15461039.1144066466033
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br>---------- Forwarded message ----------<br><span class=3D"gmail_quo=
te">From: <b class=3D"gmail_sendername">deepak pal</b> &lt;<a href=3D"mailt=
o:deepak(dot)05pal(at)gmail(dot)com">deepak(dot)05pal(at)gmail(dot)com</a>&gt;<br>Date: Apr 3, 20=
06 2:05 PM
<br>Subject: Re: [GENERAL] how to create script of database in postgres..sq=
l(winxp)<br>To: Tomi NA &lt;<a href=3D"mailto:hefest(at)gmail(dot)com">hefest(at)gmai=
l.com</a>&gt;<br><br></span><div style=3D"direction: ltr;">it do not recogn=
ize that \i and pg_dump i use \i pg_dump mydbname&gt;newdb command
</div><div style=3D"direction: ltr;"><span class=3D"e" id=3D"q_10a5fa4dc1fe=
9d91_1"><br><br><br>From the examples in man pg_dump:<br><br>&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; To dump a database:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; $ pg_dump mydb &gt; db.out<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; To reload this database:
<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ psql -d database -f db.out<b=
r><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To dump a database called my=
db to a tar file:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ pg_dump -Ft=
 mydb &gt; db.tar<br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To reload=
 this dump into an existing database called newdb:
<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ pg_restore -d newdb db.tar<b=
r><br><br>Have you tried to dump the database this way? Does it work?<br><b=
r>t.n.a.<br></span></div>

------=_Part_14521_15461039.1144066466033--