--_000_C72789658BCCtsakaigalloucsfedu_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Tom,
Many thanks for your assistance.
I am on my way. Here's what I am doing:
dropdb musket
createdb musket
pg_dump canon > canon.dump
psql -d musket -f canon.dump
I am on the 4th step. But I could achieve the same with:
dropdb musket
createdb musket
pg_dump canon | psql -d musket -f -
can't I? Aside from styling, there is no functional difference
between two procedures, is there?
Thank you.
Regards,
Tena Sakai
tsakai [at] gallo.ucsf.edu
On 11/16/09 10:42 AM, "Tom Lane" <tgl [at] sss.pgh.pa.us> wrote:
Tena Sakai <tsakai [at] gallo.ucsf.edu> writes:
> Now that I am thinking, maybe the file made by pg_dumpall has
> "canon" encoded and therefore what I did logically did not copy
> any canon tables into musket? Could this be the case?
Yup, exactly. It would have created canon and restored into that.
> If so, how would I duplicate an existing database and call it
> with a different name?
Use pg_dump not pg_dumpall.
regards, tom lane
--_000_C72789658BCCtsakaigalloucsfedu_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: [ADMIN] Failed to restore/recreate database (one more piece of i=
nfo) </TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:12.0px'>H=
i Tom,<BR>
<BR>
Many thanks for your assistance.<BR>
<BR>
I am on my way. Here’s what I am doing:<BR>
<BR>
dropdb musket<BR>
createdb musket<BR>
pg_dump canon > canon.dump<BR>
psql –d musket –f canon.dump<BR>
<BR>
I am on the 4th step. But I could achieve the same with:<BR>
<BR>
dropdb musket<BR>
createdb musket<BR>
pg_dump canon | psql –d musket –f -<BR>
<BR>
can’t I? Aside from styling, there is no functional difference<=
BR>
between two procedures, is there?<BR>
<BR>
Thank you.<BR>
<BR>
Regards,<BR>
<BR>
Tena Sakai<BR>
tsakai [at] gallo.ucsf.edu<BR>
<BR>
<BR>
On 11/16/09 10:42 AM, "Tom Lane" <tgl [at] sss.pgh.pa.us> wrote:=
<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN ST=
YLE=3D'font-size:12.0px'>Tena Sakai <tsakai [at] gallo.ucsf.edu> writes:<B=
R>
> Now that I am thinking, maybe the file made by pg_dumpall has<BR>
> "canon" encoded and therefore what I did logically did not c=
opy<BR>
> any canon tables into musket? Could this be the case?<BR>
<BR>
Yup, exactly. It would have created canon and restored into that.<BR>
<BR>
> If so, how would I duplicate an existing database and call it<BR>
> with a different name?<BR>
<BR>
Use pg_dump not pg_dumpall.<BR>
<BR>
&nb=
sp; regard=
s, tom lane<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN S=
TYLE=3D'font-size:12.0px'><BR>
</SPAN></FONT>
</BODY>
</HTML>
--_000_C72789658BCCtsakaigalloucsfedu_--
